(note the *** are removed possible sensitive information)
The path restructures itself, not in it's self an issue for me....if it worked! That's the problem, whenever I re-open after saving the links no longer update etc etc and Excel fires warnings off at me to that point.
Also this is Excel 2016 that I am working with.
I have been playing around with 2 seperate workbook test files, contained in seperate folders on the same OneDrive.
In the test files I have noticed that the problem does not happen when a different 'Path' is used for example:
However I don't seem to have any control over how that path is created as opposed to the other non working path, sometimes the first path is created by excel and sometimes it is this type created which works, or is it something I am unwittingly doing?