One Source for multiple pivot tables

[scalvitto0815]

I am using Microsoft Excel 365 MSO.

I have a data file that is used by approximately 30 pivot tables. EAch month the file path and name change so i have to go into every pivot table and change the source data location. Is there a way to enter the path and range of the data in a cell and have each pivot table refer to that cell? That way I can change location and range only on the one cell each month.

 

[ExcelToDAX]

I would get that source data and load it into Power Query. Once you get the table loaded into the file, you can then change all of the pivot tables at once by clicking Refresh All.