ExcelBanter - display revised total in Office 2003 when cell data changes

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

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

- - display revised total in Office 2003 when cell data changes (https://www.excelbanter.com/excel-discussion-misc-queries/118923-display-revised-total-office-2003-when-cell-data-changes.html)

Kerry_y

display revised total in Office 2003 when cell data changes

The total in a cell containing a formula to display the sum of two cells is
not displaying a new total when data (numbers) in one of the cells that makes
up the formula changes. the Total cell continues to display the previous
total despite the change in cell vlaue.
This may have been triggered by Smart tags but I can't seem to remove the
tag instruction.
Thank you for asssitance anybody?

Allllen

display revised total in Office 2003 when cell data changes

Tools Options Calculation tab
Set calculation to automatic.

Does that work?
--
Allllen

"Kerry_y" wrote:

The total in a cell containing a formula to display the sum of two cells is
not displaying a new total when data (numbers) in one of the cells that makes
up the formula changes. the Total cell continues to display the previous
total despite the change in cell vlaue.
This may have been triggered by Smart tags but I can't seem to remove the
tag instruction.
Thank you for asssitance anybody?

All times are GMT +1. The time now is 03:28 PM.