View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Can Not Break a Link

Click EDIT in the menu and select LINKS. In the LINKS dialog box select each
link and click the BREAK LINK command button. You'll get a warning that all
linked formulas will be converted to their current values, just click OK.

Repeat until all links are removed.
--
Kevin Backmann


"albertmb" wrote:

Hi Everyone, and yet another problem. I had a link on one sheet with
another. I removed the sheet that the first sheet was linked to and when I
open the first sheet I keep getting an alert that links can not be updated.
I am trying to break the link but it will not break. Can you please tell me
how to break this link.

Thanks in advance

Albert