Controls when and how formulas in open workbooks are calculated
static int OptionsCalculation( short int type_num, bool iter = false, int max_num = 100, double max_change = 0.001, bool update = true, bool precision = false, bool date_1904 = false, bool calc_save = false, bool save_values = true ); |
Type_num is a number from 1 to 3 indicating the type of calculation:- 1=Automatic; 2=Automatic except tables; 3=Manual.
Iter corresponds to the Iteration check box.
Max_num is the maximum number of iterations.
Max_change is the maximum change of each iteration.
Update corresponds to the Update Remote References check box.
Precision corresponds to the Precision As Displayed check box.
Date_1904 corresponds to the 1904 Date System check box.
Calc_save corresponds to the Recalculate Before Save check box.
Save_values corresponds to the Save External Link Values check box.
Zero if the function has been called successfully; non-zero if the function could not be called. See Error codes for a list of return values.
See the Microsoft Excel on-line Help for full details about this function.
Header: xlfuncs.h