Inter-spreadsheet Referencing - Continual need to locate linked fi
 

Hi,

I have been working with a few spreadsheet in different folders, most of
which are inter-linked. When opening a new spreadsheet, Excel would ask to
update links, which proceeded without issue.

However I recently re-organised my folders in a more logical manner. Of
course, this meant that Excel could no longer automatically find to the sheet
it was meant to link to. I subsequently found each sheet and updated the
links manually. This also proceeded without issue.

The problem now is, that every time I open a spreadsheet, it cannot find the
sheets that it is supposed to be linking to! Every time I open a sheet, I
have to point it to the directory that it's linked sheets are in, even though
they haven't moved for ages! How can I fix this? It's quite annoying, and
seems like it should be easy to fix considering that the files are stationery
now.

I've tried using "Edit", "Links" and updating all the links manually that
way, but it doesn't seem to work. Please advise.

Thanks for your time,
Cheers,

Peter

PS - the files are located on a network drive if that helps.