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).
Figure 3-17. Prevent unnecessary recalculations using the Calculation tab of the Options dialog box.
The default is Automatic, which means Excel will recalculate your workbook whenever the value in a cell used in any of the workbookâs formulas changes. If you click the âAutomatic except tablesâ radio button, Excel only recalculates formulas that arenât part of a data table (a data table is a range of cells that shows how changing certain values in your formulas affects the results of the formulas). If you select the Manual radio button, Excel will recalculate your formulas only when you press F9, or click the Recalculate Now button on the Calculation tab. Furthermore, unchecking the âRecalculate before saveâ box means Excel wonât update the formula results every time you save the workbookâit will do so only when you press F9, ...
Get Excel Annoyances now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.