Just moved my master copy to its final file folder home. So had to update all the links in the 'copy' workbook. A little tedious, but not painful. Here's why.

I generally work from 'Desktop', so the path was 'C:Users\camieabz\Desktop'.

I keep a catch all folder on my desktop with all my files within. Can't be bothered with Windows filing systems. So all I had to do was change the path of each linked object to (e.g.)

'C:Users\camieabz\Desktop\files\excel'.

Move the source file to its destination. Open the copied workbook, enable the content and note that it doesn't take as long, as the links are dead. Then goto 'edit / edit links to files', and see a list of the links. Click 'change source', drop in the added path data (e.g. \files\excel), without disturbing the rest, and said link will drop to the bottom of the list, as its path is longer. Repeat until the first file comes back up to the top.

Took about eight minutes to change 79 links.

In reply to a post by camieabz:

In reply to a post by martinsq:

The one that I can't work out is how to link to another sheet within the same workbook..?
It's should be obvious, but...., not to me
Thanks,
Martin

Lets say you have a sheet called 'abc' and a sheet called xyz. If you wanted to link to a cell in xyz (e.g. A1), type in a cell:
=xyz!A1
or just type in a cell '=', then navigate to the source sheet, then click on the source cell, then click enter.

Ha ! , who would have thought of exclamation mark !
Thanks,
Martin

I haven't used external referencing for several years. Just dug out an old spreadsheet that used it. It was multiple reference to the same external spreadsheet so changing one reference changes them all.

The only trouble then was that I'd referred to fixed cell references that are now in different places.

Ah well. Should have used INDEX or VLOOKUP, but at the time it didn't matter.

I find it difficult to believe that people get paid for trivial [censored] like this.

I find it difficult to believe that somebody your age persists with this standard of posting.

Perhaps it will improve when you reach double figures.

In the meantime, desist.