Speed up calculation of a worksheet that contains a data table
- On the Tools menu, click Options, and then click the Calculation tab.
- Click Automatic except tables.
Note When you select this calculation option, data tables are skipped when the rest of the workbook is recalculated. To manually recalculate your data tables, select the formula and press F9.