If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2002 -Formatting Changes not holding in Linked document
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 document, the formatting ie...COLORS doesn't change when you had changed the source document and than take alook at the document with the link to the other document in it??? 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... possibly it is the same case with Excel to Excel... not sure... thanks dano |
#2
|
|||
|
|||
Excel 2002 -Formatting Changes not holding in Linked document
Dano wrote:
Simply put, if you have a document that has a linked cell to another document, the formatting ie...COLORS doesn't change when you had changed the source document and than take alook at the document with the link to the other document in it??? Correct. Only values are transmitted across a formula link. When you initially set up the link there may be some copying of formatting but that's the end of it. You could paste a picture of the source cell over the top of the destination cell and that would show the formatting of the source cell. However, the picture will only update if the source workbook is open. Or you could write a macro to copy the formatting from the source cell when you open the destination workbook (which would mean the macro opening the source workbook). Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Excel 2002 -Formatting Changes not holding in Linked document
Hello, I have recently come across this problem - have
you managed to get this working? -----Original Message----- 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 document, the formatting ie...COLORS doesn't change when you had changed the source document and than take alook at the document with the link to the other document in it??? 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... possibly it is the same case with Excel to Excel... not sure... thanks dano . |
Thread Tools | |
Display Modes | |
|
|