Calculation time

R

RR

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
 
J

Joel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculation Time 2
Cumulative time calculation in Excel 2003 3
What does this mean? "Can't execute code in design mode" 4
Automatic calculation is not working 4
Workbook causes calculation errors 2
Formulas not calculating - Calculation is on Automatic & I pressed 2
Difference between F9 and Shift+F9 7
Spreadsheets on shared drives.. 4

Top