Hi James,

You could do it by writing a formula in cell A1 (for example) of each sheet,
linking back to the sheet that you update. Like:
=Sheet1!A1

Where Sheet1!A1 is the cell that you update.

hth
BigPig

"James" wrote:

Is it possible to update cell a1 in 7 different workbooks or files at
the same time? Thanks.