Forum Discussion
Manually choose file to query
I have an Excel workbook that queries another workbook for its content, and then do a bunch of other things. Using the 'New Query' in Excel, makes me point to a specific file to query, but in my case...
What I would suggest is to have a cell (or 2) in the worksheet to define the path & name of the file you want to open. Then just right click the file you want and copy path and then paste into the sheet and hit Refresh All data. Here is a sample link for how you can do that:
https://excelquick.com/excel-power-query/power-query-dynamic-file-path/
https://excelquick.com/excel-power-query/power-query-dynamic-file-path/