Very slow to move around a spreadsheet in Excel 2007

[juan]

Hi,

Just move from Excel XP to 2007, and one particular spreadsheet is very slow
after loading it, it opens and closes fine, but once it's opened it works
very slow, mving from one cell to another, or by pressing page down or up.
I'd checked for formulas, fonts, etc., and I can't find the reason for being
so slow. Other spreadsheets work just fine.

The original file size was around 50k, the new 2007 version is over 500k!

Any ideas?

 

[Wayne Stearns]

That's strange. In my experiences, 2007 compresses older .xls files up to
50% and makes the overall file size much smaller. Have you switched
calculations from automatic to manual? This could be your problem. Go to
Formulas tab and then select the drop down next to "Calculation Options".
Switch from Automatic to Manual. Now when you need to update calculations,
press F9 to calculate the entire workbook or Shift + F9 to recalculate only
the tab you are currently in.

 

[juan]

Thanks for your response Wayne, but I'd already tried that, and yes it is
very strange, I've been working for a while converting spreadsheets from
previous versions (XP, 2003, etc.) and this is the very first time with this
kind of problem.
--
Juan
Consulting services

That's strange. In my experiences, 2007 compresses older .xls files up to
50% and makes the overall file size much smaller. Have you switched
calculations from automatic to manual? This could be your problem. Go to
Formulas tab and then select the drop down next to "Calculation Options".
Switch from Automatic to Manual. Now when you need to update calculations,
press F9 to calculate the entire workbook or Shift + F9 to recalculate only
the tab you are currently in.

 

[SmartbizAustralia]

Sounds like you have alot of "extra rows etc...

Thought there was a bit of code around that cleans up these "big
spreadsheets" for you.

Otherwise you'd need to write a bit of vba code to rip up all the
extra rows....and columns.....

Turing off calc is frought with danger as you end up with data that
hasn't been re-calculated.

If you go that path, you'll need two buttons to turn this on and
off......

Does it have macros to record every change?

Regards,
Tom Bizannes
Excel Development
Sydney,Australia
http://www.macroview.com.au