Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data in primay field changed however subsequent field does not upd
this problem make me too irritated and wonder if anyone else has come across
this I want a report name in multiple fields thus I make one as primary field where I name it and then link other cells to primary field thus if I change anything to primary field subsequent linked fields shoudl change accordingly, however sometime it does not happen until I go to subsequent field and double click Like wise, there are five cells and say 6th field is my sum field, if I change anythig to any cell between 1-5 the total should change automatically however it does not happen till I go the total field cell and double click to update Please advise if anyone else has ever come across such wierd issue with Excel |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
data in primay field changed however subsequent field does not upd
Have you checked your calculation option? It seems it is locked on "Manual"...
-- A+ V. "tan" wrote: this problem make me too irritated and wonder if anyone else has come across this I want a report name in multiple fields thus I make one as primary field where I name it and then link other cells to primary field thus if I change anything to primary field subsequent linked fields shoudl change accordingly, however sometime it does not happen until I go to subsequent field and double click Like wise, there are five cells and say 6th field is my sum field, if I change anythig to any cell between 1-5 the total should change automatically however it does not happen till I go the total field cell and double click to update Please advise if anyone else has ever come across such wierd issue with Excel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
How do I clear the Field pulldowns after the data is cleared? | Excel Discussion (Misc queries) | |||
Show text data in excel pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Field Data | Excel Worksheet Functions |