Jan 30 2024
We have some shared Excel files, which are imported and combined into one report using power query. The problem is hat the path/source is locked to the user that made the connection: c:\\user\urename
and can not be updated by other member with access.
I have found some videoes, but they use a specific file, and not combine all the files in the folder.
What is the easiest way to solve this?