Hi,

I have made some references to other cells in other worksheets in my
workbook through VBA: worksheet.cells.formula = "= 'otherworksheet'!C2"
But when I update the source cell, the target cell doesn't automatically
refresh.

Any ideas?

Thanks in advance.