Question on Calculation Speed
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. |
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. |
Question on Calculation Speed
Mike,
Thanks for the information. Unfortunately, I need that many columns. Thanks. "Mike H" wrote: 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. |
All times are GMT +1. The time now is 10:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com