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

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...