Hi,
An immediate reaction is that you've created a monster with 600,000 cells
many of which probabaly have formula and that's a lot of calculation.
You can control calculation by setting it to manual but you should really be
asking yourself if this amount of data can be slimmed down, also have a look
here
http://www.decisionmodels.com/optspeedb.htm
Mike
"AccessHelp" wrote:
Hello all,
I have an Excel file with 60+ columns and 10,000+ rows. Whenever Excel does
the calculation and saving, it takes very, very long. Does anyone know why?
Thanks.