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


-----Original Message-----
I have a similar problem. Since adding VBA routines to
spreadsheets I use
every day, it now takes approx. 2 minutes for XL97 to
close and approx. 1
minute to close a spreadsheet. This occurs for every wb I
open regardless of
whether the wb has VBA routines. During the wait, I've
done alt-ctl-del and
noticed that XL goes into "not responding" state during
the stall. But it
almost always closes normally after the wait times
listed above. Anyone??

"Simon Ren" wrote in message
...
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?


.

"Simon Ren" wrote in news:106701c3456f$cee55bd0
:

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


-----Original Message-----
I have a similar problem. Since adding VBA routines to
spreadsheets I use
every day, it now takes approx. 2 minutes for XL97 to
close and approx. 1
minute to close a spreadsheet. This occurs for every wb I
open regardless of
whether the wb has VBA routines. During the wait, I've
done alt-ctl-del and
noticed that XL goes into "not responding" state during
the stall. But it
almost always closes normally after the wait times
listed above. Anyone??

"Simon Ren" wrote in message
...
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?

Have you tried running one of the workbook rebuilders on the files? Some
versions of VBA seem to leave "problems" in the files.

That solves my problem. I found over 2000 *.emf files.
Thanks a lot.

Simon