Hi all,

In one workbook I have a number of worksheets, all of which displays in cell B5 the same value. These all use "=" to auto-update when the cell in the first sheet is changed.

My question is as follows: is there a way to change the value on each worksheet by changing the cell in any worksheet? Currently each value will change only if I change the value in the first cell. If I try to type something in any other cell, the formula will be overwritten.

Thanks,