Opening read-only files on a network

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

At my office, we have a 20 MB Excel file that is read-only. ~150 employees
use it, many at the same time.

Many employees are saying the sheet runs and operates slowly because of the
large number of people using the file. Could this be true? I thought a
read-only file would be opened on the user's own computer, so the speed and
performance of the sheet wouldn't be impacted by the number of users. But I
could definitely be wrong.

Can anyone tell me how the file opens? Does the large number of users
impact performance of the sheet?
 
First, I don't know. But your post looked lonely <bg>.

I'd agree with your gut feeling that once the workbook is opened, it's in the pc
that opened it.

Can you test their claim? Next time someone complains about speed, open a copy
on your pc and see if it is indeed slow for you.

And here are a couple of sites that discuss slow performance. The first is by
Charles Williams and the second by David McRitchie:

http://www.decisionmodels.com
http://www.mvps.org/dmcritchie/excel/slowresp.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tracking Access in Read-Only Files 0
Update multiple files 1
Excel viewer can't use dropdown menus?? 2
Shared Workbook READ ONLY access 3
data from multiple files: best way to extract 1
File Size 1
Making a Excel file Read Only 2
Best way to pull data from several different sheets into a summary sheet 2

Back
Top