Multiple queries in one workbook. Updating source path in each

[danhendo888]

I have 20 queries in one excel workbook where the source is all pointing to the same parent folder and/or same file

Is there a bulk way to update the path name/s for all the queries without having to open each query?

e.g.

Old path --> C:\users\Daniel\Downloads\File.XLSX
New path --> D:\Users\Daniel\Downloads\File.XLSX

 

[AlienSx]

click on Data Source settings icon in PQ Editor, select old source, press Change Source button and change it to the new one.