Hi,

I am wanting to use Power Query to combine files in a specified folder. This issue is that currently I am the only one able to do the sync as the file path contains by personal path to one drive. I am unable to use a sharepoint link (or so I believe).

I have managed to amend the code in the Advanced Filter to look at a named range in the spreadsheet which contains the path name (so that anyone can amend that and then refresh the data - this was my theory)

However, in the data sources - the original path which I used to set up the connection still exists and if anyone tries to sync other than me - even though the path in the advanced filter is correct - it will still error stating it can't find my path! I am sooo close. I have tried to delete the original data source but it won't let me. I have tried clearing permissions, this doesn't work.

Can anyone help please?

Advanced Editor.jpg

Data Sources.jpg


Thanks!