Excel Onedrive and linked documents

Hi experts

I have a customer with a group of users, finance department naturally, who have loads of excel workbooks with embedded links to other excel workbooks on the same workstation. When these files get synced via the Onedrive app to Onedrive the links get completely broken because of course the absolute filenames have now changed from say c:\users\xyz\documents to c:\users\xyz\onedrive - tenant\documents

Does anyone have anysights or knowledge of a way to configure the onedrive sync app not to chnage the file paths to prevent this from happening or is there an Excel setting that will automatically update the links or perhaps a utility to find these links and update them?