Excel: The Formula Doesn’t Update in the Column

Excel2010I have encounter a problem where I have input the figure and using the same formula, but it doesn’t update the correct result even though I have clicked on the ‘Refresh’ button.

Normally, this problem is caused by the Calculation setting for Microsoft Excel.

To update the correct result with formula, please follow the steps as below:

For Excel 2010:

– Select the File tab, and from this, click on Options

Excel - File– Select the option Formulas from the list on the left of the window that pops up

– Under the Calculation options heading, select the option Automatic and click OK

For Excel 2007:

Excel option

  1. Select the option Excel Options from bottom of the main Excel menu (displayed by selecting the Excel Logo on the top left of the spreadsheet)
  2. Select the option Formulas from the list on the left of the window that pops up
  3. Under the Calculation options heading, select the option Automatic and click OK

For Excel 2003:

  1. From the top of the Excel window, select the drop-down menu Tools and from within this, select Options…
  2. Select the Calculation tab
  3. Under the Calculation heading, select the option Automatic and click OK

Thus, you will be able to obtain the correct answer by doing the automatic setting in your Excel. 🙂

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *