I don't use desktop search either, but Google still somehow managed to
install their Office COM addins on my system.
Its worth checking because its easy and it will cause exactly the kind of
slowdown you are describing.
One other thing to look at is whether you have any whole-column references
(1 million rows as opposed to 64000 rows) in your Evaluate or whether your
used-range rows is now a much larger number than it was under 2003, both
could be caused by the 2007 big grid.
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com
"Gary Keramidas" <GKeramidasAtMsn.com wrote in message
...
i run no desktop search, not even vista's. i turn indexing off and make
sure nothing runs by itself on my vista installation. don't use vista other
than to test things, i do my work in xp/ office 2003. my run times are
typically between 1.5 to 2 times slower in 2007 than in 2003.
--
Gary
"Charles Williams" wrote in message
...
Make sure you have the Google Office COM Addins disabled:
Office Button-- Excel Options--Addins --Manage--Com Addins--Go and
then deselect Google Desktop Office Addin and Google Office Desktop
Search Addin
Excel 2007 VBA will still be slower than Excel 2003 VBA, but the
difference should not be as large as you describe.
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com
"XP" wrote in message
...
Using Office XP with Office 2007.
I have a severe slow down in my code when using any For Each...Next
structure, such as "For Each Cell" or "For x = 1 to 10000"...
This slow down seems to be only in Office 2007. In 2003, my code runs
like a
machine gun; in 2007 it's more like a burp, wait a second, burp, wait a
second...etc.
This is the same code on the same machine so I'm sure my code is not to
blame since it has always run fine in 2003. At this pace, a program that
used
to run in a few seconds could now take several minutes.
Has anyone got a fix or any ideas how to make it run faster?
Thanks much for your assistance/guidance.