Deleting a link

S

Sheri

I have been given a worksheet with links to several temporary files which no
longer exist. I do not need the links. When I use tools, options, and
"uncheck" ask to update automatic links it gets rid of the message, however
it then goes to all the links that no longer exist or are required. How do I
delete the links? I have tried going into edit, links and can see them there
but I cannot seem to get rid of them.
 
S

Sheri

I am in the worksheet, I went to edit, links, and there is no "breaklinks"
that appears.
 
T

TomPl

You must be using a different version of Excel. I am using Excel 2003. The
other option is to find the formulas that reference different workbooks and
change the formulas to values (i.e. <copy><pastespecial><values>).

Tom
 
A

Ashish Mathur

Hi,

If you do not see edit links, this is one of the following happening on your
sheet:

1. Sheets are grouped; or
2. Workbook is protected.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

Link To File That No Longer Exists 1
Removing Links 3
Exterenal link 2
External data connections 1
Excel links in Word 1
User is not prompted to update links when opening spreadsheet 2
How do I get rid of expired links 3
links disabled ?? 2

Top