Excel 2000 hangs on opening a large folder, every other time.

J

Jim

Client has a large folder with a lot of spreadsheets and subfolders: 3685
sheets in 172 subfolders. The top level folder and subfloders reside on a
windows 2003 server.

If, he opens excel 2000, and then does a file/open in the top level folder
the first time, Excel hangs. The end result is a "not responding" from task
manager. If he blows excel away and then restarts excel and does the fame
file/open, the folder/file list inside the top level folder is presented
immediately.

Windows explorer has no problem opening the top level folder and displaying
the subfolders underneath, and double clicking on a spreadsheet within a
subfolder opens the spreadsheet for him.

I can't find anything in the knowledge base that explains this issue.

Does anybody have any suggestions as to what the issue is?

Thanks in advance.

Jim
 
D

Dave Peterson

Just my opinion...

The issue is the number of files/folders. Either continue to use windows
explorer to open the workbooks or reorganize the folders/files.
 
Top