Jehannum_2000
New Member
- Joined
- Sep 14, 2024
- Messages
- 17
- Office Version
- Prefer Not To Say
- Platform
- Windows
I have a .xlsm spreadsheet with a button-activated macro that runs calculations on spreadsheet data.
Each time I call the macro it takes about 0.15 seconds longer to complete, even when using the same initial data.
The slowdown becomes noticeable and obvious after a while. A calculation that previously took 0.5 seconds now takes 6.5 seconds.
If I save and re-load the spreadsheet, it goes back to its fastest speed (but again slows down on each subsequent call).
Since the re-loaded spreadsheet has exactly the same data as the saved slow version, the problem surely cannot be some unseen change in the input/output data.
Could it be because the macro is being allocated more and more memory on each use? I used Task Manager to confirm that Excel's memory allocation increases each time the macro is called.
How do I fix this?
Each time I call the macro it takes about 0.15 seconds longer to complete, even when using the same initial data.
The slowdown becomes noticeable and obvious after a while. A calculation that previously took 0.5 seconds now takes 6.5 seconds.
If I save and re-load the spreadsheet, it goes back to its fastest speed (but again slows down on each subsequent call).
Since the re-loaded spreadsheet has exactly the same data as the saved slow version, the problem surely cannot be some unseen change in the input/output data.
Could it be because the macro is being allocated more and more memory on each use? I used Task Manager to confirm that Excel's memory allocation increases each time the macro is called.
How do I fix this?
, threads don't get marked as "Solved" on this Forum
