How to Enable Auto Calculation Automatically Everytime Microsoft Excel is Opened

How to enable Auto Calculation automatically everytime Microsoft Excel is opened.

This can be done by placing a small statement in the Visual Basic Editor within Excel.

1) Accessing the Visual Basic Editor in Excel:

For Excel 2003:
Click Tools
Visual Basic

For Excel 2007:
Click Developer tab
Click Visual Basic
(If the developer tab is not showing, click the MS Office button, click popular, check Show Developer Tab)

2) After opening the Visual Basic Editor, open ThisWorkbook module

Place the following code in the Workbook_open event:

Application.Calculation = xlCalculationAutomatic

Save the Workbook