There are times when you may have a workbook that has 20 sheets with external links and you are forced to wait after every small change you make due to the size of the workbook. When those times occur, you may want to turn on manual calculation. Manual calculation turns off automatic calculation until you have completed all your changes, then you can turn it back on.

To turn on manual calc, choose tools=>options=>calculation tab=>manual=>OK

Manual calculation

You can choose to calc while manual is selected by pressing f9.

Hope this saves you some time!


Related posts:

  1. “Value” Excel Workbooks to lock in Values There are times when it is useful to remove all...
  2. Removing the Auto Hyperlink Option in Excel Today a colleague told me they were going crazy because...

This entry was posted on Friday, October 24th, 2008 at 10:46 am and is filed under Excel Quick Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Manual Calculation”

  1. sam on October 25th, 2008 at 8:49 pm

    Great info, I sue this often, saves tons of time.

Leave a Reply

You must be logged in to post a comment.