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. Excel for Windows uses the 1900 date system, in which serial numbers correspond to the dates January 1, 1900, through December 31, 9999. Excel for the Macintosh uses the 1904 date system, in which serial numbers correspond to the dates January 1, 1904, through December 31, 9999.
Remarks
Use GET.DOCUMENT to return the current calculation settings for your workbook. For more information, see GET.DOCUMENT.
Related Functions
CALCULATE.DOCUMENT Calculates the active sheet only
CALCULATE.NOW Calculates all open workbooks immediately
GET.DOCUMENT Returns information about a workbook
OPTIONS.CALCULATION Controls calculation
OPTIONS.TRANSITION Controls transition options
Return to index