Poor performance in Excel 2007

[FB]

Hi,
I am facing a very poor performance in Excel 2007. Some files I have (around
2.5 Mb each one) take almost 1 minute to open/close in Excel 2007, while in
Excel 2002 the same files take no more than 2-3 seconds.
Any idea?
Thanks.

 

[Roger Govier]

Hi

Do you have Google Desktop and/or Google Search enabled on your machine.
If so, remove them as they seriously impact performance in Xl2007.

 

[aglet]

The system requirements for running Excel 2007 are HUGE compared to Excel
2002. It sounds like you don't have enough RAM or hard disk space to run
the application efficiently.

 

[FB]

Hi,
No, I don't have those Google tools installed.
Any other idea?
Thanks.

 

[FB]

Hi,
I have 2Gb RAM and around 5Gb hard disk free. Shouldn't it be enough?
Thanks.

 

[aglet]

That should be plenty, unless you've got a lot of other apps running at the
same time. Do ALL of your files open more slowly in 2007? Is it only
files created in 2002 -- or files created in 2007 also?

 

[FB]

Not all files. I have many new files, created in 2007, that open/close fine.
I made the following test: I created a new blank 2007 file, open the
"problematic" one and copy the sheets (around 15) one by one to the new 2007
file. The problem continues in the new file too. Then, I tried to copy sheets
separatelly, trying to isolate the problem. After each sheet, I closed/reopen
the file. But I didn't reach any conclusion; the file becomes slowly after
each sheet (it means, not a single/problematic sheet is causing the problem).

 

[aglet]

Hmm. Then I'm afraid I'm out of ideas. I remember having one file that
gave me similar problems a long time ago (I forget which version I was
migrating to). I did the same thing you did -- copied each sheet
individually -- and got the same results. I finally had to recreate the
entire file. Fortunately for me, I only had one file that was a problem.

Do you have anything in your personal.xls file that might be running in the
background that is slowing things up? How about different option settings
in 2007 vs 2002? Autocalc turned on vs off? I don't know. I'm just
grasping now.