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
Macros
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