Slooooow opening of a file (2002)

Topic

New Reply

It takes more than 10 minutes to open a file. The file size is about 11MB. No VBA in this workbook. Is there any suggestion on this strange behavior?

System: WinXP+ Office XP

Reply | Quote

Replies

Is the workbook on the local hard disk, or on a file server? If it is on a file server, does it also open slow if it is copied to a local hard disk? Does it contain a lot of links to other workbooks that must be updated when the file is opened? Does truning virus protection off on the workstation have any affect?

Reply | Quote

Local file
No links to other workbooks or files
About 20 worksheets with simple formula (+,-,*,/)
Scanned with NAV, no virus found.
No NAV installed in the system

This file was about 2-3MB in Excel97. It blows itself to 11M under Excel2002.

Reply | Quote

Here is a shot in the dark for something to try. Open the file and do a File/SaveAs and save the file to Type HTML under a different name. Close Excel. Start Excel back up and open the HTML file and then do a File/SaveAs back to .xls type (don’t replace the original file). Does the resulting file now open more reasonably? If so, check to see if anything like formatting was lost in this process before you delete the original .xls file?

Reply | Quote