Feedback by UserVoice

Dural Lash

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
    Dural Lash commented  · 

    Thanks for raising this issue,

    I have found I can select the pivot table copy to a new sheet, maintaining the original pivot.
    I then paste special as values in the new sheet, then go back to the original copy table again and then paste special formats.

    Hope this helps

    You used to be able to copy the P table, then paste special values and then paste special formats which was quick and easy :)

    regards
    Epi

Feedback and Knowledge Base