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? |
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