break a link in excel 2003
 

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?

break a link in excel 2003
 

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.

damienmc wrote:

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

break a link in excel 2003
 

Thanks Dave

"damienmc" wrote:

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?