Open your document in Excel. You can either open your document from within Excel by going to File > Open or you can right-click on the file in your file browser, select Open With and Excel.
Click the Formulas tab. You'll see this in the editing ribbon above the document space.
Click Calculation Options. You'll see this under the icon of a calculator in the "Calculation" group.
Select a calculation rule. You can choose: Automatic: the default option that tells Excel to refresh the calculation any time information in the formula's data range is edited. Automatic Except for Data Tables: also tells Excel to recalculate any formulas if the data in the formula's cells changes. Manual: turns off auto-calculations in Excel so you'll have to calculate manually.
Comments
0 comment