Excel stopped storing links with relative file path - what to do?
In my organization we have a shared drive with a number of Excel workbooks that link to each other. For years, this have worked according to Microsofts description here: https://support.microsoft.com/en-us/topic/description-of-workbook-link-management-and-storage-in-exc...
About a year ago, without any change from our side, all our links started behaving as absolute references instead of relative. This is a huge problem for us since it means we can't copy a folder with it's subfolders and have the files still link to each other. (For example, we want to take a structure of files and try out how a new scenario would affect them, or we want a copy of the structure but for a new time period.)
I've seen questions like this before, although some are for sharepoint/onedrive setups. So far I've found no answers as to why it's not working on a shared drive.