Feedback by UserVoice

Space

My feedback

  1. 34 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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 comment
    Space commented  · 

    You certainly have another solution without having to copy and paste. You can right-click Tab from your original data file, and select Make a Copy onto an Empty excel Workbook. That copy you made would still contain all the collapse property and filters of your original pivot table. While your recipient can have functional flexibility but they will not access to the Original Data file. Whatever they do on their end, will not affect your data file. If you are concerned about the Pivot Table List and filters, you can hide them all in the Background.

    This should help someone.

Feedback and Knowledge Base