Home |
Search |
Today's Posts |
#1
|
|||
|
|||
when i change data in a sum forumla, the sum doesn't change?
Under Tools-Options-Calculation make sure Automatic is checked
"richard_kta" wrote: i am doing a simple sum formula, using it several times in the worksheet, and it used to work fine, however, suddenly now the formulas are only working after the initial calculation, if i go back and change data later on, the formula doesn't reflect any changes and special pasting of the formula only reproduces the value of the original calculation! I want the Sum function to work as it should. Reflect changes as they are made and be able to paste a function to another group of cells! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query Data Source Change | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Change Text Data to Date | Excel Discussion (Misc queries) | |||
How do I change a cell so I can have the data it contains in seve. | Excel Discussion (Misc queries) | |||
change font color of first cell in data table attached to chart | Charts and Charting in Excel |