I have a project folder on onedrive (personal) which is accessed by all concerned.

However, queries created via local (offline) onedrive, have a data source that goes "c:usersloginnameonedriveRproject"

As a result other users are unable to refresh the queries when they open the same workbook.  It tries to find the same file path on their desktop.

I went through the tutorial in PQ on Dynamic Link and folderpath.  I am going to try that later today.  Nevertheless, I was wondering if there is a way to point data source for all queries to workbook on onedrive, which eliminates the need to create dynamic folder path link.

Will it work better if we move shared folder to say a dropbox or boxsync, instead of onedrive.

One solution I still have to try is to change location of Onedrive to c: for all users.  But that is not really the best solution.

Help would be sincerely appreciated.

Nz