Here is a snip from an e-mail from one of my clients...
Our nurses have an excel folder that has one file for every resident. Each
file for each resident is updated one time a month. It is 728kb in size.
The files have quite a few check boxes. The files are on our network drive.
We have 2 computers that routinely access the files. Both of these
computers are having a difficult time accessing the files. It takes 3-4
minutes or more for the file to open. On all of the other computers the
file opens without difficulty. But other computers do not routinely access
the file.
and the 2 computers in question have been reloaded with xp pro and office
2000 and where working fine and just started this again lately...
Tia

Signature
ZÿRiX
tristan.huxley@prox-e-mics.eu - 13 Feb 2007 12:34 GMT
Hi Zyrix,
If you are using VBA for the computers to access these files, I would
suggest looking at the network path file coding, only because if it is
dynamic, (ie; refering to a cell on a worksheet, or a function), it
can sometimes take much longer to open, manipulate, manage and
close...
If this is only specific to these two PC's, then I would suggest that
you get your IT group to ensure that the spec's are the same, and if
that is the case, find a pc that is the same and get it cloned and
loaded onto these two problematic PC's.
The only possible other thing that it might be is if they have a lot
of {array} formulas in it or volatile formulas in it which can in some
instances make a small file harder to manage.
Hope this helps you
> Here is a snip from an e-mail from one of my clients...
>
[quoted text clipped - 14 lines]
> --
> ZÿRiX
Dave Peterson - 13 Feb 2007 14:12 GMT
First thing I'd try is to clean up the windows temp folder.
Close excel
windows start button|Run
%temp%
is a quick way to get there.
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
If that doesn't help, then the next thing I'd try is to copy a few of those
files to the C: drive--just for testing. If those files open quicker, then
maybe it's a network problem and you should show the results to your IT folks.
> Here is a snip from an e-mail from one of my clients...
>
[quoted text clipped - 14 lines]
> --
> ZÿRiX

Signature
Dave Peterson