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

Question

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?

Answer 1

Hi @Dawn, Emily,

Under PivotTable Analyze tab- select Change Data Source:

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.