Friday, February 22, 2013

How to Stop Auto Recalculation Upon Data Entry in Excel


1. Open Microsoft Excel, and then open a new or previously saved workbook.
2. Click 'File' at the top of the screen. Click on 'Options' in the drop-down menu that appears. The 'Excel Options' window opens.
3. Click 'Formulas' on the left side of the window. Under 'Workbook Calculation,' click 'Manual.'
4. Click the 'Recalculate workbook before saving' check box if you want to turn this option off as well. Click 'OK' to close the window.

Blogger news