Excel is very slow to load/save the spreadsheet

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?
 
S

Simon Ren

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%.
 
C

Clark

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%.
Have you tried running one of the workbook rebuilders on the files? Some
versions of VBA seem to leave "problems" in the files.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top