Thread: Excel 2007 Goal Seek Macro Running 7 times slower than Excel 2003
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thomas Shortt Thomas Shortt is offline
external usenet poster
  
Posts: 1
Default 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 ***
Reply With QuoteReply With Quote