I have a shared spreadsheet in Office 365 with links to an Access query however other users cannot update the spreadsheet as the file path linking to access is C:\local user\ - the Access database is on a shared office 365 folder.
The file path can be changed but one you select the Access Database from the online shared folder it makes the file path c:\local user\ etc
Is there a way around this ?
