My feedback

1. Break link from source data to pivot table

   34 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   (thinking…)

   

   Password

   Sign in with: Facebook Google

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   23 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   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  ·  Oct 29, 2018
   An error occurred while saving the comment
   Rene Noel Cruz commented  ·  Oct 29, 2018  ·  Edit…  ·  Delete…

   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.

   Save Submitting...