Formatting not retained using paste all and paste link
 

When using the paste all with the paste link function for an entire
worksheet between a source workbook in Excel and a destination workbook in
Excel, the formatting is not retained in the destination workbook's
worksheet. Must I reformat all the cells in the destination workbook manually?

Formatting not retained using paste all and paste link
 

Formulas return values--not formatting.

So you could either do it manually or record a macro (when you copy|paste) when
you do it once and replay that macro if you need it again.

ABCMS wrote:

When using the paste all with the paste link function for an entire
worksheet between a source workbook in Excel and a destination workbook in
Excel, the formatting is not retained in the destination workbook's
worksheet. Must I reformat all the cells in the destination workbook manually?

--

Dave Peterson