Maybe it's me... but your terminology has me confused.

A spreadsheet.... usually refers to one, single worksheet (one tab) in
Excel.
A work book... usually refers to a complete, saved Excel file (regardless of
how many worksheets it may contain).

So are you talking about cells on different worksheets within a single
workbook (file). Or in multiple Excel workbooks (each with different file
names)?

Kathryn Groves


"John.Tucker" wrote in message
...
I have an excell spreadsheet that contains several work books. if I make a
change in the first workboot (master) I would like that change to happen
in
each of the other workbooks where the master cell is referenced. Example:
I worksbooks A B C D E F, If I change the color of a cells contents in A4
then I would like that change to appear in any of the other workboot that
reference A4

In workbook B for cell C5 I have a link that looks like this =A!A$