Forum Discussion
Power Queries and external connections
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.
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
1 Reply
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