Discussion Locked

Removing link to worksheets

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
We have an Excel 97 worksheet that has links to 2 worksheets that we want to remove. Where and how would I go about removing those links? Thanks for any help.

5 replies

by jmar17

Thanks for your suggestion. I was able to find the link by going to Edit and Links but as for removing the actual links I needed to go to the individual formulas for the links.

by insatiable

If you're talking about hyperlinks, you do it this way:

Right click on the hyperlink and choose Hyperlink/Edit Hyperlink.

It will pull up the "Edit Hyperlink" window and you can use the "Remove Link" button on the bottom left.

Once the linkis removed, the cell will still show the Filename/Label of the worksheet it was pointing to. You can delete those characters like any other cell you normally edit.

I hope this helped.
Good luck!
Melissa

by jmar17

Thanks but they are links to other worksheets. See above for how it was solved.

This discussion is closed to new replies.