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.