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 commentAnonymous commented
Thanks for the response, however I think it misses the point (may be a difference in perspectives of a developer vs. an end user of the product).
I'll try to explain. I find pivot tables incredibly useful and powerful in making sense of large quantities of data.
One key use I have is where I have a series of pivot tables on a sheet showing various summary information (approx 20). I don't want the person I share this with to have access to the base data as it would cause privacy issues. They do however want to make further use of the values in the cells (so pictures wouldn't help). So currently to create the flat tables I have to copy/paste values and then do a lot of manual formatting to make the data presentable again.
As you can appreciate from the Excel users who have expressed this as an issue, along with the many a varied attempts to find workarounds, many users are frustrated by not being able to simply copy/paste a pivot table as a standard 'flat' table along with the formatting.Anonymous supported this idea ·