Nov 14 2022 08:06 AM
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.)
Does anyone know what might cause this problem?
Is there anything we can do to have the links stored as relative again?
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.
Dec 07 2022 10:02 AM