Feedback by UserVoice

Tina W

My feedback

  1. 34 votes
    Sign in
    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
    Tina W commented  · 

    Thank you Thomas K. I have unselected the "save source data with file", and it did break the link. The problem is anyone open the excel can select the "save source data with file" and see all the detail data. Any suggestion to solve this?

Feedback and Knowledge Base