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

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
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.
 
Back
Top