Monday, 10 September 2012

Change Formula Options

Click the Office button, and then click Excel Options.
Click the Office button, and then click Excel Options.
In the left pane, click Formulas. 
           Select the calculation options you want:
           Workbook Calculation.
           Enable iterative calculation.
           R1C1 reference style.
           Formula AutoComplete.
           Use table name in formulas.
           Use GetPivotData functions for PivotTable references.
Use GetPivotData functions for PivotTable references.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)