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...
Just to add to this issue, I have just run a macro which was taking around 1 second to populate each cell and suddenly it started working as it did with Excel 2007. That is overall excepting that every so often it would slow down for a cell or two and then pick up speed again.
So for anyone who has suggested that the problem is with the way the code is written I would suggest that this evidence suggests that the code is not at fault but something in the VBA handling and/or interaction with Windows 10 is causing the problem. If only we could persuade Microsoft that this is the case and get them to fix the underlying problem. Of course, as has been suggested, this may be a deliberate ply to get us to stop using VBA. If so, what are MS offering as an alternative.
So for anyone who has suggested that the problem is with the way the code is written I would suggest that this evidence suggests that the code is not at fault but something in the VBA handling and/or interaction with Windows 10 is causing the problem. If only we could persuade Microsoft that this is the case and get them to fix the underlying problem. Of course, as has been suggested, this may be a deliberate ply to get us to stop using VBA. If so, what are MS offering as an alternative.
px03afkAny update on this ? I have the same problem since, I believe, a "windows intelligence" update from February 3rd. Macros are much slower (X 100). Seems to be linked with updating cells.
No update. As I said, the code was old. I tarted it up some. It is a little better because of that.
Edit: Not much better. It is still terrible.
I am having the same issue with the macros in my organization, they are too slow.
- I have the same problem: Current Excel for Microsoft 365 (Win 10) is now slow to run and slow to close after running macros from an excel file. These same files and macros still run fine on Excel 2003 and Excel 2007 on alternative Win 10 PCs, and the same macros ran fine on the now-slow PC UNTIL recent updates of Microsoft 365 / Excel 365 on that PC.
