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?

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?

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?

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

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