Assume I have a spreadsheet on a network drive: //net1/mydir/sheet.xls
The drive is mapped to g:
In the same directory, I have another sheet, with links to the first file, e.g. A1='sheet.xls'!A1
I have 2 questions:
1. Why can this not be a relative link. If I copy both sheets to another location, I want it to reference the 'local' copy, not the original.
2. Even if I have 'sheet1' open and then open sheet2, it still asks me if I want to update links, and then asks me to locate the file. It appears to be thinking that g: and //net1/ are different drives. No amount of trying to force it with Edit->Links seems to solve this.
I really would prefer the relative linking idea, but any incite into Excels mechanisms for resolving links would be much appreciated