Add option to avoid OneDrive from changing Excel references to other files
Everytime you link an Excel workbook to other workbook, OneDrive changes the reference to the file, making reference to an online files. However, if one the Owrkbooks are in differente folders inside OneDrive, the link will break, even if you try to open the file in the computer containing them. That is a HUGE problem
Have the same problem! Anyone find a solution?
Same problem. Really frustrating as I have workbooks with hundreds of external links.
This is a crazy functionality in this age of "cloud" designed workflow. Even if the excel files are opened from the OneDrive folder, it seems I need to save the file for the data to refresh across the links, The only way to work successfully at the moment is to relink the files to the local onedrive directory everything I open the workbooks.
Or stop using OneDrive!
Same problem from day 1. 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. This is a MAJOR problem. This renders one of the most vital functionality of Excel useless!
I get the same issue. Oddly enough, I can use those same files on Google Drive with no issues...and I don't pay them anything!
J o commented
I can not store Excell nor Word files to OneDrive. What do I do wrong ??
Russell Morris commented
Yep, same problem here, and it's a big PITA. Is there really no way to fix this (i.e. let me point to my "local" file)?
I also have the same issue. Excel converts the workbook reference to a https:// reference within OneDrive however all the links are broken even if the associated source files are open. If you go through and repair the links everything is ok the reference is returned to its original format e.g. ='Device Audit and Classification.xlsx'!Table3[Printer Serial Number]. This is frustrating as every time I open the destination sheet I need to update a handful of links. This would not be an issue on a traditional file share. Is there some way to reference the sheet such as an absolute reference used in formulas?