PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes Calculation rate slows to a trickle

Reply

Calculation rate slows to a trickle

 
Thread Tools Rate Thread
Old 02-07-2003, 02:51 AM   #1
Ken
Guest
 
Posts: n/a
Default Calculation rate slows to a trickle


I run a series of macros simultaneously. The macros do a
lot of copying of both formulas and values. When the macro
sequence gets to a certain point the calculation rate
begins to slow down tremendously. If I save the file and
exit Excel completely and then get back in and continue
the macro sequence where I left off, the calculation rate
is fast again. It appears as if system resources
(Memory?) are being used up as the macro is run to the
point where the calculation performance is degraded.

I'm trying to understand what's happening, and find a
Visual Basic command that I can place in between macros in
a sequence that will free up system resources as exiting
Excel appears to do.

Any help would be greatly appreciated.

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off