"Change Data Source" feature disabled for Pivot Table on PowerPivot in Excel 2013 RRS feed

  • Question

  • Hi

    I am trying to repoint from external sql connection to local sheet/table connection and the option in Excel 2013 and 360 is disabled.

    My excel file has 10 pivot tables and dependent charts from -pointing to- an external sql data connection.

    Current steps taken:

    1. I have created an extra sheet/table and created a new test pivot table on the basis of the sheet/table and added it to the data model.

    2. I have also created an ocd file for both the sql connection and the datamodel.

    3. As an attempt to hack the connection I have pointed the sql connection to the datamodel ocd and excel complains of illegal/corruption file with a message.

    So I am at a loss at the moment,

    Please help! :)


    Wednesday, March 27, 2019 1:26 PM

All replies