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