| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formulas
I have simple functions in my workseet - e.g. summing 3 cells to get a total.
When I change the value of one of the cells, the total does not change. I cannot figure out why. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel formulas
Maybe check to make sure calculation is set to automatic
Tools/Options/Calculation/Automatic. If a workbook is saved w/calc set to manual, Excel's calculation will be set to manual every time you open the workbook. "Sonora" wrote: I have simple functions in my workseet - e.g. summing 3 cells to get a total. When I change the value of one of the cells, the total does not change. I cannot figure out why. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
| Printing Excel Formulas without file paths updating | Excel Discussion (Misc queries) | |||
| Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions | |||
Hybrid Mode
