Feedback by UserVoice

Tim Green

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
    Tim Green commented  · 

    Thomas K, you are right, you can paste values, then formats. Unfortunately, most of the formatting features of a pivot table are completely lost when you do this. Borders, shading and bolding is lost. All that is pasted correctly is row heading indentation and number formatting.

Feedback and Knowledge Base