If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|