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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel-how to link source workbook to copy of destination workbook 1
Paste link only - not value 4
Sorting Linked Data Between Sheets 3
Move or Copy Worksheet 6
Excel 2007 Move or Copy worksheet 2
VBA code for pasting links -- modifying RDB code for summary workbook 10
External workbook links don't update when source file changes 1
sort source data sheet while destination shows same data 1

Back
Top