Need some help

[=?iso-8859-1?B?Wv9SaVg=?=]

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

 

[tristan.huxley]

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

 

[Dave Peterson]

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.