| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 - How to display 761000 in a cell as 761 | Excel Worksheet Functions | |||
| Excel control cell display of data with passwords | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| MS Excel 2000 Cell Capacity and Data Display | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
