Excel is very slow to load/save the spreadsheet

  • Thread starter Thread starter Simon Ren
  • Start date Start date
S

Simon Ren

I developed some VBA code in an Excel spreadsheet. I found
that Excel becomes slower and slower to load and save the
spreadsheet. The CPU usage runs at 100% for a couple of
minutes before the spreadsheet is opened.

The problem does not seem to be the spread sheet itself.
The same spreadsheet can be opened in another machine in
normal speed.

The slowness seems to build up during my development. The
spreadsheet crashed several times during the develeopment.
I suspect the crash somehow affect the Excel
instanllation. Any one have any idea what could cause this?
 
Just add another piece of information. Once the
spreadsheet is opened. It runs normally. It just the
loading/saving takes long time and CPU goes to 100%.
 
Just add another piece of information. Once the
spreadsheet is opened. It runs normally. It just the
loading/saving takes long time and CPU goes to 100%.
Click to expand...
Have you tried running one of the workbook rebuilders on the files? Some
versions of VBA seem to leave "problems" in the files.
 
Back
Top