CALCULATION

Macro Sheets Only

Controls when and how formulas in open workbooks are calculated. This function is included for compatibility with Microsoft Excel version 4.0. For controlling calculation in Microsoft Excel version 5.0 or later, see OPTIONS.CALCULATION.

Syntax

CALCULATION(type_num, iter, max_num, max_change, update, precision, date_1904, calc_save, save_values, alt_exp, alt_form)
CALCULATION?(type_num, iter, max_num, max_change, update, precision, date_1904, calc_save, save_values, alt_exp, alt_form)

Arguments correspond to check boxes and options in the Calculation dialog box. Arguments that correspond to check boxes are logical values. If an argument is TRUE, Microsoft Excel selects the check box; if FALSE, Microsoft Excel clears the check box.

Type_num is a number from 1 to 3 indicating the type of calculation.

Type_num Type of calculation

1 Automatic

2 Automatic except tables

3 Manual

Iter corresponds to the Iteration check box. The default is FALSE.

Max_num is the maximum number of iterations. The default is 100.

Max_change is the maximum change of each iteration. The default is 0.001.

Update corresponds to the Update Remote References check box. The default is TRUE.

Precision corresponds to the Precision As Displayed check box. The default is FALSE.

Date_1904 corresponds to the 1904 Date System check box. The default is FALSE in Microsoft Excel for Windows and TRUE in Microsoft Excel for the Macintosh.

Calc_save corresponds to the Recalculate Before Save check box. If calc_save is FALSE, the workbook is not recalculated before saving when in manual calculation mode. The default is TRUE.

Save_values corresponds to the Save External Link Values check box. The default is TRUE.

Alt_exp corresponds to the Transition Formula Evaluation check box in the Transition tab of the Options dialog box.

• If alt_exp is TRUE, Microsoft Excel uses a set of rules compatible with that of Lotus 1-2-3 when calculating formulas. Text is treated as 0; TRUE and FALSE are treated as 1 and 0; and certain characters in database criteria ranges are interpreted the same way Lotus 1-2-3 interprets them.
• If alt_exp is FALSE or omitted, Microsoft Excel calculates normally.

Alt_form corresponds to the Transition Formula Entry check box in the Transition tab of the Options dialog box.

• This argument is available only in Microsoft Excel for Windows.
• If alt_form is TRUE, Microsoft Excel accepts formulas entered in Lotus 1-2-3 style.
• If alt_form is FALSE or omitted, Microsoft Excel only accepts formulas entered in Microsoft Excel style.

Note Microsoft Excel for Windows and Microsoft Excel for the Macintosh use different date systems as their default. For more information, see NOW.

Remarks

Use GET.DOCUMENT to return the current calculation settings for your document. For more information, see GET.DOCUMENT.

Related Functions

CALCULATE.DOCUMENT Calculates the active document only

CALCULATE.NOW Calculates all open workbooks immediately

GET.DOCUMENT Returns information about a document

OPTIONS.CALCULATION Controls calculation

OPTIONS.TRANSITION Controls transition options

List of Command-Equivalent Functions