View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default loss of speed with excell 2007

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