Home

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
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.
Related Conversations
Sum 2 pivot table Fields where one may not exist
shotgun-68 in Excel on
0 Replies
Help with forumla
robwill100 in Excel on
0 Replies
Graphic
Allan1951 in Excel on
0 Replies
Macro works fine on Excel 2016 - causes crash on Excel 365
gpflinn in Excel on
1 Replies
formula FREQUENCY - FRECUENCIA
jeissonmarroquin in Excel on
0 Replies
Changing Data Source Struggles
cjkim92 in Excel on
2 Replies