EXCEL 2010 slower than EXCEL 2007?

Dean A

New Member
Joined
May 13, 2011
Messages
2
My remote client and I have a new file running a macro and it seems to be running twice as slow on his new computer with EXCEL 2010 versus my older computer with 2007. The two computers are at different locations. "Prior experience" was that things in EXCEL were just the reverse, that his EXCEL setup was more than twice as fast as my old one.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
<o:p> </o:p>
I know that I am introducing two variables here (two computers) and two versions of EXCEL but if you would humor me (because of the “prior experience”) on that and answer the following question:<o:p></o:p>
<o:p> </o:p>
Do you know of circumstances within an EXCEL file and macros where the 2010 version is slower than the 2007 version (on the same computer). The primary operation that is taking so long is a macro that is doing a goal seek. <o:p></o:p>
<o:p> </o:p>
Mr. EXCEL, In an article you wrote on the internet, you talked about 2010 possibly being slower than 2007 for DAO applications but it seemed that DAO had something to do with links to ACCESS, and I know our file does not use ACCESS. But perhaps it has something to do with regular EXCEL, too?<o:p></o:p>
<o:p> </o:p>
Any thoughts as to why 2010 might be slower than 2007 (I’m not talking about 2003)? <o:p></o:p>
Thanks!<o:p></o:p>
Dean<o:p></o:p>
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Please withdraw this post. Today, his computer is running faster again. Not sure why, possibly a reboot fixed it. Sorry
 
Upvote 0
Welcome to the Board!

No worries. I'd imagine someone will come along with some possible reasons for that behavior, but it's good to know it got resolved. Chalk another one up to the memory gremlins.

(And we don't generally remove posts here unless you really upset someone. ;) )
 
Upvote 0

Forum statistics

Threads
1,224,618
Messages
6,179,917
Members
452,949
Latest member
beartooth91

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top