Excel 2002 - Formatting NOT Changing in Linked Document

[dano]

Hello,
I've got a problem with formatting changes not updating in linked
document...

Simply put, if you have a document that has a linked cell to another
worksheet, the formatting ie...COLORS doesn't change when you change the
source document with the linked document???

Yes, for instance text will be updated... but again, not formatting like
making it BOLD or changing the colors of the text!

Any ideas... I did see a KB article 1009182 regarding a problem linking WORD
with Excel... but not Excel with Excel and the formatting not holding... it
possibly is the case with Excel to Excel to... not sure

thks Dano

 

[Dave Peterson]

Formulas can only return values--they can't copy the formatting.

Maybe if you only have a few options, you can use format|conditional formatting
to that cell.

 

[dano]

Yes, it is the same machine... version 2002 of Excel... weird... does NOT
hold formatting... only contenst or values!
Dano

 

[Dave Peterson]

My response was that formulas can not return formatting. That's just the way
excel works.

 

[dano]

ok... yea... it was just really text that was being changed in a cell
and/or the background for a stoplight chart if you will...
I appreciate the input and reponses...

Thks
Dano