I want to link tables from an Excel file to an Access file, create a query and then link that query back to Excel. I have tried to do this on SharePoint and OneDrive for Business. But when I switch computers, or other people in my team try to update the Excel file after filling in new data, the link seem to be broken.

Do you know how to create a linked table between Access and Excel within a SharePoint library?