Working with a Pivot Table when Data Connection is Removed? RRS feed

  • Question

  • Hi all,

    We have a pivot table that pulls information from a data cube. We'd like to have several users working with the spreadsheet not to have connection to the cube, but still be able to work with the current "snapshot" data on the pivot table.

    However, once removing the data connection, we can no longer use filter/sort options on the pivot table and get an error stating that  the data connection has been removed.

    Is there any way to keep the snapshot of the pivot table and still be able to manipulate the data as it is in-state?

    Monday, November 4, 2019 3:56 PM


  • Hi,

    This is by default behavior in Excel, in my opinion there is no method get the result you need in Excel.


    Emi Zhang

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Tuesday, November 5, 2019 7:59 AM