Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changes in data do not lead to instantaneous update of results
For some reason when the data in my spreadsheet is changed the result is not
updated to show this change in the source data. For instance if a formula is set to add all the cells between range a1 and a5 and cell a3 is changed then the result still shows the addition of the old data. However when you save the spreadsheet the result does update to the new data correctly. Also if you delete the formula and re-enter it it does also show the correct result. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changes in data do not lead to instantaneous update of results
Tools Options Calculation Automatic
-- Gary''s Student - gsnu200758 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changes in data do not lead to instantaneous update of results
Thank you very much. That sorted it out.
"Gary''s Student" wrote: Tools Options Calculation Automatic -- Gary''s Student - gsnu200758 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to update a chart from filtered results | Excel Discussion (Misc queries) | |||
Instantaneous cell values from a PLC | Excel Discussion (Misc queries) | |||
instantaneous cell value | New Users to Excel | |||
Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions | |||
Help!: lead sheet data needs to fill appropriate subject sheets | Excel Worksheet Functions |