ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2007 Goal Seek Macro Running 7 times slower than Excel 2003 (https://www.excelbanter.com/excel-programming/417077-excel-2007-goal-seek-macro-running-7-times-slower-than-excel-2003-a.html)

Thomas Shortt

Excel 2007 Goal Seek Macro Running 7 times slower than Excel 2003
 


Help. I have a macro that runs a goal seek function on hundreds of rows,
one row at a time. It takes 7 times longer in Excel 2007. I have already
tried the following:

application.screenupdating=false
application.enableevents=false
application.multithreadedcalculation.enabled=false

Any help?

Thanks
Tom

*** Sent via Developersdex http://www.developersdex.com ***


All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com