Excel increasing slowdown, in multiple versions

[Richard]

I've Excel VBA macros which repetitively open 100+ data
files (no more than 4 open at once), do heavy number-
crunching, save results, then do it all over again a few
hundred times with slight variations in parameters. It
takes a week to run one of these, and using the Timer
function I discovered that the time taken to do one
iteration slowly increases from 10 minutes to over an hour
(even though the data and calculations are the same) and
despite all effort to close files as soon as finished,
etc. I use Excel 2000 (9.0) and read in the Microsoft
knowledge base that there are memory leak/slowdown bugs
supposedly fixed by Service Release 1/1a, which I applied,
to no effect. Then I tried installing Excel XP and found
that the increasing slowdown still was there (and Excel XP
in total runs noticeably slower than Excel 2000, so I'm
back with Excel 2000). No error messages generated and it
eventually successfully finishes, but it just slowly slows
to a crawl as it runs. The OS is XP Home. Restarting Excel
(without rebooting) gets it going fast again. Any
suggestions as to where to look for this problem, how to
narrow down or diagnose it, fix it, etc.? Thanks!

 

[Quandan - Marcel Kreijne]

Richard,

I have experienced Excel to slow down after heavily changing a spreadsheet.
I noticed that saving the workbook solves the issue most of the times.

You can save the workbook using VBA code as well, so you wouldn't need
to stop your macro to do so. Hope this will work for your issue too!

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - dutch supportsite for spreadsheetusers)
www.quandan.nl