Hi All,

I am not really sure if this would be classed as an Excel problem or a Microsoft file problem in general so I apologise if you think this in the wrong forum.

At work at the moment I am using Windows 2000 and Excel 2002 and have been charged with the task of reorganising the files on the computer into a more logical and neater format. The only problem with this is that a lot of the Excel files have links to other files and so if I move the folder containing the Link Source or I change it's name this completely messes up the link.

I have been looking around for a while for a solution but cannot seem to find one (save for manually renaming and redirecting all the links).

Is there a way to have the links update themselves if I change a folder or file name so that I do not have to edit the links? Or is this a real downfall with links in Excel as everything seems to be pointing to?

Any help would be greatly appreciated.

Many thanks,

Chris