link spreadsheets with data and format
 

I have create a spreadsheet D and using Paste link from other 3 other
spreadsheets (A, B, C) in the same workbook. The text shown corrently on
spreadsheet D after the link, but it did not capture the format like font
colour, bold or italic from what I have done in spreadsheet A, B & C. Can
someone help me on this?

link spreadsheets with data and format
 

You cannot link formatting, only contents.


Gord Dibben MS Excel MVP

On Fri, 22 Jun 2007 19:53:00 -0700, PL wrote:

I have create a spreadsheet D and using Paste link from other 3 other
spreadsheets (A, B, C) in the same workbook. The text shown corrently on
spreadsheet D after the link, but it did not capture the format like font
colour, bold or italic from what I have done in spreadsheet A, B & C. Can
someone help me on this?