Linked table manager link without username

Copper Contributor

Is there a way to connect an excel file that is saved on a SharePoint site without my username in the link?

The issue is that our DB is saved on a sharepoint drive and my co-worker and myself need to update the linked file each time one of us works on the DB.

 

Ex: C:\Users\MyUserName\SharePointLocation\MyExcelFile.xlsx

 

 

1 Reply
Maybe this will work for the link:
%USERPROFILE%\SharePointLocation\MyExcelFile.xlsx