keeping text format in linked cells

[carourke]

I am trying to keep the format of the original cell when I link it to another
workbook. There are several employee names, one employee name per cell, all
cells are linked to another workbook. One week the name john doe will be
changed to BOLD text in the original workbook, which will need to be
reflected in the linked workbook, The next week, Becky Sue Smith's name will
be changed to bold in the original workbook and the change in text will have
to be shown in the linked workbook.

 

[Gary''s Student]

Linked cells return only the value and not the format.