Equivalent to clicking the Options command on the Tools menu, and clicking the Calculation tab in the Options dialog box. Sets various worksheet calculation settings.
Syntax
OPTIONS.CALCULATION(type_num, iter, max_num, max_change, update, precision, date_1904, calc_save, save_values)
OPTIONS.CALCULATION?(type_num, iter, max_num, max_change, update, precision, date_1904, calc_save, save_values)
Arguments correspond to check boxes and options in the Calculation tab in the Options 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.
Note Microsoft Excel for Windows and Microsoft Excel for the Macintosh use different date systems as their default. For more information, see NOW.
Return to index