mha112897

New Member
Joined
Jan 6, 2016
Messages
1
I've seen many posts about retaining the pivot table formatting when pasting values to unlink it from the source. The paste special values does not work. I've tried using the clipboard to paste and it worked one time. In the same workbook attempting to copy and paste the values and formatting of other pivot tables does not work with subsequent attempts. It is so frustrating and illogical that the same sequence does not work. I tried clearing the clipboard and starting again.

Any ideas???

Thanks.
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

VeryForgetful

Board Regular
Joined
Mar 1, 2015
Messages
242
I normally select entire PivotTable then copy. I then paste special values in a new column followed by paste special formats to the same range of cells. You can then delete the table.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,400
Messages
5,571,907
Members
412,425
Latest member
MalCorn
Top