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$

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$

You have a workbook that contains several worksheets.

The bad news is that excel's formulas return values--not formatting like you
want. And excel is very good at "pulling" the data (using formulas). It's not
so good at "pushing" the data somewhere else.



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$

--

Dave Peterson

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$