| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
linked cells not updating
Hi,
Can anyone tell me why my linked cells would not update when a change is made? ='Line Items'!F9 I change the value in F9 on the Line Items tab and my value on this tab does not change. Can anyone help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
linked cells not updating
If I doubl click the cell and hit enter the value does update.
What's going on? "Karen53" wrote: Hi, Can anyone tell me why my linked cells would not update when a change is made? ='Line Items'!F9 I change the value in F9 on the Line Items tab and my value on this tab does not change. Can anyone help? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
linked cells not updating
Could it be because I set it up in a procedure ? Did I miss something?
ActiveCell.FormulaR1C1 = "='Line Items'!R[-1]C[-8]" "Karen53" wrote: Hi, Can anyone tell me why my linked cells would not update when a change is made? ='Line Items'!F9 I change the value in F9 on the Line Items tab and my value on this tab does not change. Can anyone help? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
linked cells not updating
Has calculation been accidentally changed from Automatic back to Manual
(Tools|Options Calculation tab) in this workbook? Do other same-sheet formulas update OK? -- Regards, Bill Renaud |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
linked cells not updating
Thank you, Bill. That was it.
"Bill Renaud" wrote: Has calculation been accidentally changed from Automatic back to Manual (Tools|Options Calculation tab) in this workbook? Do other same-sheet formulas update OK? -- Regards, Bill Renaud |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| updating linked cells after inserting a row | Excel Discussion (Misc queries) | |||
| updating linked cells after inserting a row | Excel Discussion (Misc queries) | |||
| updating linked cells | Excel Discussion (Misc queries) | |||
| cells linked to others in same workbook not updating | Excel Discussion (Misc queries) | |||
| updating linked cells | Excel Discussion (Misc queries) | |||
Linear Mode
