A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel 2002 -Formatting Changes not holding in Linked document



 
 
Thread Tools Display Modes
  #1  
Old December 17th, 2003, 01:54 AM
dano
external usenet poster
 
Posts: n/a
Default 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  
Old December 17th, 2003, 09:31 AM
Bill Manville
external usenet poster
 
Posts: n/a
Default 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  
Old January 14th, 2004, 04:12 PM
ST
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.