PowerPivot Office 365 does not allow "Change Data Source" - Greyed out RRS feed

  • Question

  • Hi!

    I have my main database and queries in MS Access, and link Power Pivot data model to that source. it works great!

    I have multiple pivot tables built on the data table linked and refreshed from MS Access.  Works Great!

    Now I want to move my MS Access source from a USB drive to the cloud.  A second table linked to the cloud source works great!

    How can I direct the pivot tables to pull from the new table.  (They are identical)

    The approach should be:  Place curser in an existing pivot table and select change data source.  However, this option is greyed out.  All other attempts to change the data source are also greyed out.

    Sometimes my efforts will result in the pivot table losing all information.

    Please Help!



    • Moved by Dave PatrickMVP Friday, November 6, 2020 12:51 AM looking for forum
    Friday, November 6, 2020 12:31 AM