Forum Discussion
Excel Macro Runs *PAINFULLY* Slow
I have an issue running an Excel Macro. I have read a lot of threads and tried all of the suggestions but no change in performance. I have run the same file/macro on 2 machines, details below. No mat...
Hi,
I'd like to add that I have experiecned the same performance issue with a recent patch.
Macros that used to take a couple of mins to run are now taking hours.
Excel is eating up a lot of memory.
once the macros are complete, excel takes an age to close the file, or shut down.
setting application.calculation = xlManual has helped restore some of the performance, but the memory usage is still high and excel doesn't close down properly.
I'd like to add that I have experiecned the same performance issue with a recent patch.
Macros that used to take a couple of mins to run are now taking hours.
Excel is eating up a lot of memory.
once the macros are complete, excel takes an age to close the file, or shut down.
setting application.calculation = xlManual has helped restore some of the performance, but the memory usage is still high and excel doesn't close down properly.
I contacted Microsoft again, today, this time via via https://support.microsoft.com/home about this 'slow macros / slow to close Excel 365' issue. After outlining the issues (including the 4 x extra use of memory by Excel 365 for the same macros now, compared with Excel 2007), running an online 'Repair Office' remote session, the Excel 365/Macros issues persisted, no change, no fix.
However, I have now been assured that this issue will be passed to the relevant Microsoft Tech Team for analysis and a fix.
"The tech team releases updates every month, so I'd need you to be patient for the next update to be rolled out".
A fix in the next release of Office 365 should be the right solution to this current (slow) Excel365/Macros problem, I'm hoping!
However, I have now been assured that this issue will be passed to the relevant Microsoft Tech Team for analysis and a fix.
"The tech team releases updates every month, so I'd need you to be patient for the next update to be rolled out".
A fix in the next release of Office 365 should be the right solution to this current (slow) Excel365/Macros problem, I'm hoping!
I am hoping you are right. But the fact that they do not seem to be putting VBA support into their online versions while simultaneously trying to push everyone into the online versions says to me that they want to kill macros.
I bet there is a PowerPoint somewhere at MS HQ where they have the number of people who use macros, our ages, and the rate we die on a graph.
They tried this before, and it was the birth of Libre Office.I mean, if I am not running macros, why run the app version of office? If I am running Office through a browser, why would I spend for Windows at all?
It will take people about 15 seconds to decide to go to Libre/Google on Ubuntu.
