Posted to microsoft.public.excel.worksheet.functions
|
|
Increase Speed of Calculations
All about Excel speed:
www.decisionmodels.com
and
http://msdn.microsoft.com/en-us/library/aa730921.aspx
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"bob" wrote in message
...
My worksheet has about 100,000 calculations and is very slow in
calculating
them. It is taking me about 5-8 minutes to calculate the entire worksheet
on
a machine that has 4GB of RAM. The worksheet size is 21 columns by over
6,000
rows. Do anyone know of a way to increase the calculation speed without
breaking the data ino several different workbooks?
|