I have a file that has links to a number of other spreadsheets. Sometimes when I have the file open and then open one of the linked files, the links for that file all change to #REF . Sometimes, it is the whole file path and sometimes it is the worksheet within the linked file that is replaced with #REF . What could be causing this?