Power Queries and external connections

[Anonymous]

I am working on 12 monthly files and linking them to another external file that will compile them YTD.

The 12 monthly files have quite a number of worksheets (25 offices/worksheets for each month). I've created a Power Query to combine all of the 25 tabs to generate a report that will give me a monthly view.

Next I take the data that is generated by the monthly Power Queries and have connected them (Existing Connections/Browse.../connections in this workbook).

Everything was working perfectly during my creation of these files. Now, down the road, I am having my users input their data. When I open the YTD file, the data is not automatically refreshed. I have tried what I know to update settings to select automatically refresh upon open, but that is not working.

Any help would be welcomed and appreciated.

[BA_Pete · Accepted solution]

Hi @Anonymous ,

In the absence of any details about what you've tried to make this work, the best I can do is offer you a link to the MS documentation to check that this is what you've tried:

MS Support refreshing Excel connections on open and close 

Pete