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

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

Similar Threads

this code is VERY slow, is it the code or perhaps a worksheet issue 32
Excel 2007 runs slow after upgrading CPU from dual to quad core 4
excel 2000 very slow resorting spreadsheet 1
Very slow to move around a spreadsheet in Excel 2007 3
VBA vs C#: filling a spreadsheet with random numbers - C# 4x slower... 5
Strange CPU deadlock in very short macro 0
A solution to Excel2007 slowness when running Excel 2003 macros 1
Calculating is very slow 3

Top