AX2757

Enabling or disabling auto-calculation

You may want to change your spreadsheet auto-calculation settings while you are setting up files.

To toggle auto-calculation on or off:

• In the Excel Client: On the Formulas tab, in the Calculation group, select Automatic or Manual.
• In the Windows Client: On the Home tab, in the Calculation group, select Automatic or Manual.

Also, note the following differences in the calculation options for each client:

• In Excel, you have the option to calculate the current sheet only (Calculate Sheet). This option is not available in the Windows Client.
• In the Windows Client, you have the option to calculate the current workbook only (Calculate Workbook). This option is not available in Excel.
• Both clients have the option to Calculate Now, which calculates all open workbooks.