ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Increase Speed of Calculations (https://www.excelbanter.com/excel-worksheet-functions/210608-increase-speed-calculations.html)

Bob

Increase Speed of Calculations
 
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?

Niek Otten

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?




All times are GMT +1. The time now is 04:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com