34 votes23 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
If we break the link to the data, the PivotTable will no longer be interactive and won’t support expand/collapse, filtering, or sorting. Copy/Paste into Paint or any other graphics program will preserve an exact picture of the PivotTable with all formatting. In any event, this item isn’t likely to be addressed soon.
An error occurred while saving the commentDural Lash commented
Thanks for raising this issue,
I have found I can select the pivot table copy to a new sheet, maintaining the original pivot.
I then paste special as values in the new sheet, then go back to the original copy table again and then paste special formats.
Hope this helps
You used to be able to copy the P table, then paste special values and then paste special formats which was quick and easy :)