Formatting not retained using paste all and paste link

A

ABCMS

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?
 
D

Dave Peterson

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.
 
Top