I have tried looking but cannot find the option anywhere.
I have a file that has links pointing to other files. If I have the main file open and one of the files it links to, save the file it links to into a different location, excel will change the link path.
How can i stop Excel doing that?