break a link in excel 2003

[Guest]

I have a spreadsheet (call it spreadsheet A) which has links to 2 other
spreadsheets (B&C). One of these spreadsheets(C) i have now deleted. However
when i try and break the link to C(edit/breaklink) in A it also removes the
link to B saying 'breaking links permanently converts external references to
their existing values'....is there anyway i can keep the link to B and just
remove the link to C?

 

[Dave Peterson]

Try Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

There's an option to ask what to do for each link.

 

[Guest]

Thanks Dave