How do you remove automatic hyperlinks to other workbooks ?

[horbury]

When merging two documents both with hyperlinks, how do you remove links to the other workbook ?. So that the message 'The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with the changes made to the other workbooks ?
click YES or NO, does n't appear when opening the document...

 

[SQLBI]

Hi,

If you're using Excel 2002(xp) then select Edit > Links, find the link you want to delete from the list and click Delete/Remove Link.

If using Excel 2000/97, this function is not available.



Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[Dreamboat]

YOu can avoid the problem by pasting using Edit-Paste special-Values.

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[KenWright]

If you are using 2000 or 97 then download Bill Manvilkles free addin FINDLINK.xla. It will sort that out for you:-

http://www.bmsltd.co.uk/MVP/Default.htm

Regards
Ken................

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------