| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Unable to get a correct total when changing data within a formula
Doing a simple formula Cell A-Cell B and when I change data in cell A or B,
the total is not changing automatically. I event started a new excel sheet and it is doing the same thing. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable to get a correct total when changing data within a formula
try:
Tools Options Calculate and check automatic. -- Gary''s Student - gsnu200763 "JMac" wrote: Doing a simple formula Cell A-Cell B and when I change data in cell A or B, the total is not changing automatically. I event started a new excel sheet and it is doing the same thing. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Unable to get a correct total when changing data within a formula
ToolsOptionsCalculation.
Make sure you are set to automatic. Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 11:34:01 -0800, JMac wrote: Doing a simple formula Cell A-Cell B and when I change data in cell A or B, the total is not changing automatically. I event started a new excel sheet and it is doing the same thing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| £ keeps changing to$ how to correct | Setting up and Configuration of Excel | |||
| My excel formula is correct, however, my total is off by .01. | Excel Worksheet Functions | |||
| Changing colors of a formula total. | Excel Discussion (Misc queries) | |||
| sum of total hours not correct | Setting up and Configuration of Excel | |||
| unable to total a column | Excel Worksheet Functions | |||
Hybrid Mode
