ExcelBanter - breaking links

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - breaking links (https://www.excelbanter.com/excel-discussion-misc-queries/159063-breaking-links.html)

How do you remove a link that is not correct. I tried to break the link but
it tells me it is workbook is protected. The problem is a user tried to
change the name of a workbook to cse.cs3excel (notice the extension) and it
changed it in the links. I need to delete this one from the Links, but it
will not allow me to.

If you unprotect the workbook (tools|protection|unprotect workbook, in xl2003),
can you remove the link?

And you're sure that the warning wasn't because one of the worksheets was
protected, right?

Pammy wrote:

How do you remove a link that is not correct. I tried to break the link but
it tells me it is workbook is protected. The problem is a user tried to
change the name of a workbook to cse.cs3excel (notice the extension) and it
changed it in the links. I need to delete this one from the Links, but it
will not allow me to.

--

Dave Peterson