Excel no longer capable of Relative links

%3CLINGO-SUB%20id%3D%22lingo-sub-1189929%22%20slang%3D%22en-US%22%3EExcel%20no%20longer%20capable%20of%20Relative%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1189929%22%20slang%3D%22en-US%22%3EMy%20excel%20is%20no%20longer%20ever%20storing%20links%20as%20relative%20links.%20This%20is%20super%20problematic%20as%20I%20need%20to%20reference%20a%20series%20of%20workbooks%20within%20a%20file%20and%20compare%20results%20with%20a%20government%20regulator.%3CBR%20%2F%3E%3CBR%20%2F%3EWhat%20makes%20this%20worse%20is%20that%20when%20Excel%20fails%20to%20find%20the%20folder%20structure%20it%20doesn't%20use%20the%20saved%20values%20but%20updates%20to%20a%20previous%20version%20of%20the%20files%20that%20were%20opened%20accessing%20files%20not%20in%20the%20same%20folder%20or%20even%20drive%20in%20some%20test%20cases.%3CBR%20%2F%3E%3CBR%20%2F%3EDoes%20anybody%20know%20what%20could%20possibly%20be%20going%20on%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1189929%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1190318%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20no%20longer%20capable%20of%20Relative%20links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1190318%22%20slang%3D%22en-US%22%3EDo%20the%20files%20happen%20to%20be%20in%20a%20OneDrive%20or%20Sharepoint%20folder%20%3F%20If%20so%20I%20think%20this%20is%20an%20existing%20and%20known%20bug.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor
My excel is no longer ever storing links as relative links. This is super problematic as I need to reference a series of workbooks within a file and compare results with a government regulator.

What makes this worse is that when Excel fails to find the folder structure it doesn't use the saved values but updates to a previous version of the files that were opened accessing files not in the same folder or even drive in some test cases.

Does anybody know what could possibly be going on?
1 Reply
Highlighted
Do the files happen to be in a OneDrive or Sharepoint folder ? If so I think this is an existing and known bug.