Can Not Break a Link

A

albertmb

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
 
K

Kevin B

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.
 
A

albertmb

Thank You for answering Kevin. This is exactly what I have been doing but it
does not work. In the "Edit Links" the status is 'Source not found'. Does
this make any difference?

Thank You
Albert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

break links not working 39
Break a link between workbooks when there is no "break" option 2
Link won't break in Exel. 2
Link? 1
Link won't break 1
HOW 2 BREAK AN OPERATION 2
Break out of a loop in Excel2007? 8
Break Link - unsuccessful...try diff. ways... 1

Top