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 commentKevin commented
This work around doesn't really meet my company's business needs. We have a massive data file across 24 clients, each with 10-250 user IDs registered to them and the output is every screen visited in a third party mainframe and each time they visited it last month for each user id. All told I have ~140k records with 6 fields that need to be sorted first into client, then into user ID, then display the screens for each of them. This report gets viewed by all the team leads at our company (because we get charged for each screen load in this mainframe) and in order to let them sort through the table effectively I need to maintain the collapse/expand features of the pivot tables. The clipboard workaround doesn't achieve that.
Please change this feature in future updates of excel! I'm sending out an 8 MB report every month which is being downloaded onto roughly 100 different computers on our network. That's 9,600 MBs of space being taken up on our network every year just from this one report!