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?