Hi,

Do the following:

If you have copied the cell and pasted in your Excel sheet using the Paste
Special commad, then you must click the Psste link button in the Paste
Special dialog box.

The paste link paste the absolute value of the cell reference, therefore you
will not have any problem. Then, on the Tools menu, click Options. In the
Options dialog box, click the Calculation Tab. select the Save external link
Value check box under Windows option. Then click OK to accept the setting in
the Options dialog box.

Challa Prabhu

"John.Tucker" wrote:

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$