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 commentStacy Davis commented
copy and pasting, then reformatting..really? This is very time consuming and so 2010. There must be a better way. Next excel version.. please give us an option to unlink the data source and covert to standard table. Cant be that hard. Thank you!Stacy Davis supported this idea ·