Speed up calculation of a worksheet that contains a data table - Help and How-to

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Speed up calculation of a worksheet that contains a data table

Applies to: Microsoft Office Excel 2003

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, press F9.

Get Office 2007

Buy Office 2007
Download a free 60-day trial

See Also

Buy Microsoft Office 2007
Free trial of the 2007 Microsoft Office system
Tables I: Create and format basic tables

Printer-Friendly Version

Original page: http://office.microsoft.com/en-gb/help/HP052030301033.aspx