Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation Efficiency (Speed)? | Excel Discussion (Misc queries) | |||
Calculation Speed | Excel Worksheet Functions | |||
Calculation speed issue | Excel Discussion (Misc queries) | |||
Calculation Speed | Excel Discussion (Misc queries) | |||
Maximum Calculation Speed | Excel Worksheet Functions |