ExcelBanter - formula referencing cell not updating

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula referencing cell not updating (https://www.excelbanter.com/excel-discussion-misc-queries/259240-formula-referencing-cell-not-updating.html)

Dave

formula referencing cell not updating

Hi

I have a formula referencing a cell to give interest based on the amount in
the referenced cell. When I put a numeric value in the referenced cell the
cell with the formula does not update. When I click into and out of the cell
the formula works.

Does anyone know what this is?

Thanks

Pete_UK

formula referencing cell not updating

You may have the calculation mode set to Manual. Click on Tools |
Options | Calculation tab (2003 menus) to set it to Automatic.

Hope this helps.

Pete

On Mar 18, 2:29*pm, Dave wrote:
Hi

I have a formula referencing a cell to give interest based on the amount in
the referenced cell. When I put a numeric value in the referenced cell the
cell with the formula does not update. When I click into and out of the cell
the formula works.

Does anyone know what this is?

Thanks

All times are GMT +1. The time now is 04:43 PM.