Formatting not retained using paste all and paste link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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