Macro run Very Slow in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just got my Office 2007 and tried to run my Macros developed under Excel
2003. Then I found it runs very very slow. I campared many of my macro and
found all of them run much slower than in Excel 2003. Is there anything
wrong? Or anything I can do to improve it?
Thanks.
 
Hi, in my opinion, you should set references to all the add-ins your macros
refer to. Also, you should check your computer's RAM and operating system, if
it is capable of handling advanced software such as Office 2007.
 
My Macro does not include any Add-ins. Also, my computer has big enough RAM
to handle Office 2007. After try agin and again, I found there are many
differences to handle Chart between Office 2007 and Office 2003. Such as
Shape property and many many others. I have to modify my Macro to fit Office
2007 if I want to use it. In my experence, a Macro that working on many
Charts developed under Office 2003, if working in Office 2003, it may take 2
minutes. Working in Office 2007, take 2 more hours. After modified to fit
Office 2007, now take about 3 minutes. Conclusion: Use macro developed under
Office 2003 in Office 2007 may slow down a lot. You have to modify it to fit
Office 2007 if you have to use Office 2007. It is offset.
I heard many people has same nightmare in my company.
 
Back
Top