linked cells not updating

[Guest]

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?

 

[Guest]

If I doubl click the cell and hit enter the value does update.

What's going on?

 

[Guest]

Could it be because I set it up in a procedure ? Did I miss something?

ActiveCell.FormulaR1C1 = "='Line Items'!R[-1]C[-8]"

 

[Bill Renaud]

Has calculation been accidentally changed from Automatic back to Manual
(Tools|Options Calculation tab) in this workbook?
Do other same-sheet formulas update OK?

 

[Guest]

Thank you, Bill. That was it.