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 commentJen commented
I wish for the ability to copy and paste values and formats without the underlying data too. I have found if I copy and paste the pivot table into Word or Outlook and then copy from there and paste into Excel, it accomplishes this goal.Jen supported this idea ·