Excel 2013 VBA runtime vs Excel 2010 and 2007
Posted on 2015-02-04
I build a re-rating application in VBA which ran perfectly under office 2010 even under office 2007, without loosing speed during run time.
The App re-rates "Customer calling record", the results which do come out are then used for analysis purposes. In fact it's a full functioning Mini "Mobile Billing engine" which simulates several scenario's for financial optimisation purposes.
The tool came in several versions, but worked "bug free" "fast" and "perfectly fine" on Office 2010 at a fast speed.
Due to company policy, I was forced to upgrade to office 2013 a few weeks ago, but since then the problems began.
VBA runs significantly slower, which make that simulation run times last now for several minutes instead of seconds. Big ones even take up to 30 min while in Office 2010, it was only a matter of a few minutes.
Funny thing is that the App starts fast, but slows down as scenario's and time are progressing. ( changing affinity/priority does not help)
In terms off optimizing, I did already all necessary to optimise on screenupdating, events, calculation, you name it, ...
Does anyone have the same problem. Problem is that my collegues are dependent on the app and the outcome, and currently, the App becomes too slow to work with, especially when larger simulations are required. Are there any know issues in VB 2013 where I should be aware off, and do you have any suggestions how to solve the issue.
Thank you and best regards