Fix problem that changes linked Excel file location
When creating a link between data in two Excel sheets without OneDrive, the program links to the file location on the hard drive. Once OneDrive is in place, Excel forgets the hard drive location and tries to link to the OneDrive web location which results in an error message. This is a MAJOR problem. This renders one of the most vital functionality of Excel useless!
Alfredo Herrera commented
that functionality is very important
Doug Scott commented
As a workaround you can do a Save As on the Excel file with links to other workbook and it will not change the links to web location but will leave them pointed to the local OneDrive location.
I totally agree. Ran into this problem with a client today that MOVED from Google Drive and Google Sheets to O365. Free Google Drive does this flawlessly and a paid subscription of Office 365 with OneDrive CAN NOT! Embarrassing. Please allow LINKS in excel sheets to work with OneDrive.