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.Anonymous supported this idea ·
An error occurred while saving the commentAnonymous commented
I agree on the importance of being able to delink the data source from the results. I want to copy the pivot table and manipulate it, but can't due to the linking of the data source.