Forum Discussion
Excel 2016- Pivot table and Power query
Dear All I have an excel 2016 spreadsheet where i have information, someone previously set up a power query and pivot table, however i am unable to refresh the data I have changed the file path b...
Hi , Try these
Open Queries & Connections from the Data tab, right-click the query, select Edit, and update the file path in the Power Query Editor.
Click Close & Load to save changes after updating the data source.
Ensure the Pivot Table references the updated query by selecting Change Data Source under PivotTable Analyze.
Use Refresh All in the Data tab to refresh both the query and Pivot Table.