| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUM Total
I am having trouble tracking down a solution for an issue with Excel.
I am using a sum formula that will only update a 'total' when I hit the save icon? In other words, it wont update the total when I change a value of a cell in the formula range. Any ideas? |
|
#2
|
|||
|
|||
|
Joe
Check your calculation setting: Tools, Options, Calculation Steve "Joe" wrote in message ... I am having trouble tracking down a solution for an issue with Excel. I am using a sum formula that will only update a 'total' when I hit the save icon? In other words, it wont update the total when I change a value of a cell in the formula range. Any ideas? |
|
#3
|
|||
|
|||
|
Thanks, Steve. That was it!
"Steve R" wrote: Joe Check your calculation setting: Tools, Options, Calculation Steve "Joe" wrote in message ... I am having trouble tracking down a solution for an issue with Excel. I am using a sum formula that will only update a 'total' when I hit the save icon? In other words, it wont update the total when I change a value of a cell in the formula range. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have total for filtered data?? | Excel Discussion (Misc queries) | |||
| keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
| how to add time total in msg box | Excel Discussion (Misc queries) | |||
| Total remaining formula | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
