r/excel•
CapK473

Power query won't refresh due to different shared drive locations among users

unsolved

I have a few power query excel files that grab files from a location on the shared server and then merge them together and update a mini report/table. It works fine for me but when other try to use it, it will not refresh. It seems to be because when we get access to a shared drive, users can assign whatever letter drive they want to it. So mine is the T: drive, while someone else might have U:. When the query goes to get the files it can't find them for other users since it's looking for the T drive, and that's not the letter they have assigned.

I've tried changing the file permissions, but they were already set to None.

I'm about to go on a prolonged medical leave and was hoping my team would still have access to updating these mini reports.

Is there a way to write a get data script that will ignore the letter at the start of a pathname?

Thank you in advance.

Posted Oct 17, 2023, 4:54 PM UTC

11

No comments yet

Nobody commented on this post, or the comments weren't captured.