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?
