Power Pivot Excel Add-in references old filenames/file versions when tables in the workbook are added to data model

Dawn, Emily 0 Reputation points
2023-03-22T02:07:12.0266667+00:00

I've added several tables within an Excel file to the Data Model for that same Excel file (by clicking Power Pivot>Tables>Add to Data Model). Power Pivot is using that Data Model for reporting, all within the same workbook.

When I save the file under a new name, the Data Model continues to refer to the old file version. I can't find any way to update the data source. The "Table Properties" function is grayed out for those tables within Power Pivot. Any recommendations?

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,457 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 21,706 Reputation points Microsoft Vendor
    2023-03-22T09:25:49.6466667+00:00

    Hi @Dawn, Emily,

    Under PivotTable Analyze tab- select Change Data Source:

    User's image

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments