Feedback by UserVoice

Rene Noel Cruz

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.

    Rene Noel Cruz supported this idea  · 
    An error occurred while saving the comment
    Rene Noel Cruz commented  · 

    Why can't Excel do this from within Excel if:
    In SSRS, i can connect to a SSAS Tabular Model, create a pivot table and save the report to Excel with the link disconnected to the data source (report now has static data), the table format intact and the row drill down still working.

Feedback and Knowledge Base