I must be the luckiest XL 2007 user in the world because I see these posts
constantly and have never experienced performance degradation on my workbooks.
In any event, here's an informative white paper about Excel 2007
performance:
http://msdn2.microsoft.com/en-us/library/aa730921.aspx
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"halfpint" wrote:
My previous spreadsheet developed with excel 2000 is very fast compared to a
very slow 2007. the file is over 100 meg with a lot of formulas, pivot
tables. plotting is extremely slow with 07 and excessively slow when
opening/closing grouped rows or using filters. Although I've turned off
background error checks and even auto calculations it still appears there's a
lot of recalclations going on in the background with 2007. xcel 2000 doesn't
do this and is very fast. I don't know what to try next...helpppp--
halfpint