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

Chapter 3. Formula Annoyances > RECALCULATION ANNOYANCES

RECALCULATION ANNOYANCES

RECALCULATE NOW!

The Annoyance:

The formulas in my workbooks use many values from other sources—and because the source data changes frequently, Excel has to recalculate the formulas constantly. This takes up so much of my computer's processing power that much of the time it's impossible to get anything done. Can I control when and how Excel recalculates my formulas?

The Fix:

To control when Excel recalculates the formulas in your workbook, select Tools → Options, and click the Calculation tab (shown in Figure 3-15).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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