Link won't break in Exel.

L

Linda R.

I accidantly copied a worksheet from another workbook into my Excel file and
then moved it back. Now I get a link update message each time I open the
file. I go to Edit > Links and select "break link" but it won't go away. I
have tried searching for the link in the workbook and it finds nothing. What
can I do to get rid of this erroneous link?
 
S

Susan

try this:
in your spreadsheet, hit Ctrl + backwards apostrophe - it's the button
(usually) to the left of the number one button above the Q button.
make sense? LOL.
when you do that, it will "open" up all your formulas, and will also
open up links, making them easily visible. then you can delete it
manually.
then hit Ctrl + backwards apostrophe again to "zip up" your formulas.
hope that helps.
:)
susan
 
G

Gord Dibben

Your "link" could be in "refers to:" for a named range.

Have a look under Insert>Name>Define.


Gord Dibben MS Excel MVP
 

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

Top