Slow File Open accesst to files

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

Guest

When using Excel 2002, and file open and going to mapped
network drive folder that has 1000 files in it, it takes 4
to 5 minutes for the files to be listed in the file open
window.
If I go to Windows Explorer and browse this same folder
the files are shown right away.

On a different PC with Excel 2000, the file open list is
populated right away.

Any ideas?

Roger Konwinski
 
My first suggestion would be to move some of those 1000 files into separate
subfolders. Not only will it make excel's life easier, it should make it easier
for humans, too.

But sometimes cleaning up the windows temp folder will help speed up other
aspects of Excel. (I don't know if it'll have any affect on your situation,
though.)

You may want to take a look at these two sites (Charles Williams and David
McRitchie):

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

Maybe you'll see something that can help.
 
Back
Top