indesign and onedrive linking Issue

Hi,

I've searched a bit across the internet, but didn't find a solution (yet). We are currently using OneDrive to store a excel files in there. The files are synced and shared with each team member's. But we have a problem with InDesign: the links don't work when you try to relink it to the excel file. We have tried to relocate the excel file outside of the onedrive and copy the excel file and also relocate it but it keeps telling me it cant be linked. Does anyone have an answer for this issue?