Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation time
I have a pretty complicated worksheet (23MB). As such, I keep the
calculation mode set to Manual. When I hit the F9 key to calculate, it can take either 4 seconds or 15 minutes. The latter finally calculates properly but EVER SO SLOWLY. Can someone explain why it seems to get hung up sometimes when other times it flies through the math? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculation time
Excel has an internal formula to determine which cells have to get updated
based on the cells that got changed. The formula execution time will be different depending on which cells have been modified. I have a pretty complicated worksheet (23MB). As such, I keep the calculation mode set to Manual. When I hit the F9 key to calculate, it can take either 4 seconds or 15 minutes. The latter finally calculates properly but EVER SO SLOWLY. Can someone explain why it seems to get hung up sometimes when other times it flies through the math? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculation (Subraction of Idle Time) | Excel Discussion (Misc queries) | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
Please help with time calculation | Excel Discussion (Misc queries) | |||
time calculation with military time | Excel Worksheet Functions | |||
Time Calculation | New Users to Excel |