• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. Excel Settings to Change > Turning Off Automatic Calculation

Turning Off Automatic Calculation

By default, Excel automatically recalculates a worksheet when you change a value in the worksheet. As the worksheet grows more complex, calculation takes more time. For very complex worksheets, you might want to change the way Excel handles recalculation.

You can choose Tools, Options to open the Options dialog box and then select the Calculation tab (see Figure 22.2).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint