View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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