Microsoft Office Tutorials and References
In Depth Information
Skip Data Tables When Calculating Workbooks
Chapter 4: Getting More Out of Formulas
4 Click to select the
Automatic Except for
Data Tables option.
4
5 Click OK.
The next time you
calculate a workbook,
Excel bypasses the data
tables.
5
Try This!
When you want to recalculate a data table,
you can follow steps 1 to 3, click to
deselect the Automatic Except for Data
Tables option, click OK, and then
recalculate the workbook. On the other
hand, you might prefer to leave the
Automatic Except for Data Tables option
selected. In that case, to recalculate the
data table you select any cell inside the
data table and press F9.
More Options!
If you often turn the Automatic Except
for Data Tables option on and off, Excel
offers a faster method for toggling this
setting. Click the Formulas tab, click
Calculation Options in the Calculation
group, and then select the Automatic
Except for Data Tables option.
Alternatively, from the keyboard, press
Alt+M, press X, and then press E.
 
Search JabSto ::




Custom Search