View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Question on Calculation Speed

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.