Excel

Hi David,

You can amend or delete your links using the edit menu. When you go into the Edit menu Links is towards the bottom. The Edit Links box appears showing you all the links in that file, and then click on the link you want to amend or delete. Once you have clicked on Links it will give you five choices of what you want to do. All linked files should update and when you open the file you will get a box appearing asking you if you want to update, however if not then click on Update Values. If you need to amend your link i.e. the file location has changed then use Change Source. This will open the box similar to file / open, and allow you to search for it's new location. If the link is pointing to the wrong cell then use Open Source. This will allow you to open the source file and let you find out where it should be pointing too. You will then have to go into the cell containing the link and change it manually. If you want to delete a link then choose the Break Link option. You will get a box appearing just confirming you want to do it but once you click break link then it deletes it. Check Status just makes sure the link is working correctly.

Regards
Martin