I have both versions and can take a look.
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KMH" wrote in message
...
I have a file that should work fine, but is incredibly slow to navigate in
2007. It takes over 30 seconds to just open a row group and running some
macros that require calculations on slows it down from seconds to minutes.
I
am going to try it in Excel 2003 on an old computer as well to see if 2003
to
2007 is the issue, but any help or suggestions are appreciated.

Description of file...
Laptop is HP 8730W 3 GHz 3GB RAM
Windows XP Professional Version 2002 SP2
~4MB in size Excel 2007 now but originated in 2003
Primary Worksheet = about 4000 rows and only about 64 columns
There is quite a bit of conditional formatting and formatting in general
but
nothing Excel 2003 couldn't handle.
A few offset functions but these are disabled in an IF statement
A few IRR calcuations that returned #NUM or DIV#0 but these have been
disabled via IF statement (If(Iserror(....))
I used to have a short macro that worked in the background if the sheet
changed, but that is turned off now as well.
There are no data tables or pivot tables in the sheet. Therefore changing
to automatic calcs without tables won't help.



Is there any way to dedicate more resources to Excel or find out where
exactly Excel is bogging down????

Thanks