Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste contents from other spreadsheet | Excel Worksheet Functions | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) | |||
Importing Data From Another Spreadsheet | Excel Discussion (Misc queries) | |||
How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) |