I have an excel file that contain a vba macro. This was working fine until two weeks ago. However, it has slowed significantly after the patch update 14827.20158. Prior the update, the tool used to run in less than 2 minutes. Now it is taking more than 40 minutes to complete. Also noticed that the CPU utilisation spikes to nearly 100% as soon as the macro starts running. Is this caused due to any change included in the patch update?
Did you also discover what parts or specific operations of the VBA macros appear much slower?
I tried to introduce some debug logging to find out which statements were taking time. So, I added some lines to write date time and a debug statement into a worksheet. This time, the macro took 3.5hours.
I tried this in another PC where I had the version before the patch update and the macro completed in just over 1 minute (1m 4s to be precise). So, I think any assignment of a value into a cell is taking time. The logging was very extensive. In every loop, I had a line being written into a debug worksheet. But, I wasnt expecting the performance to degrade to this level. The 1m 4s, I mentioned above also included exactly the same number of debug log entries
Hi Sivan,
I have the same issue as well! Once you identified that assigning a value into a cell takes time, how did you go about fixing this?
Thank you,
Aditya
4 people are following this question.
