Deleting a Link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've copied a worksheet from another workbook. When I open
the file to which I have copied the message states that
there is a link to another file. I don't want this list to
exist. How can I delete this link. I've tried to lock the
link on Tools/Options/Calculation by removing the tick on
the Update Remote Reference box but it continues to stay
there.
 
Copy your new sheet and paste values. That will remove the links.

Copy

Paste speacial

values
 
You must log in or register to reply here.

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
Deleting a link 4
Picture Links printing problem - Help! 1
Delete All Links to Worksheet 1
Excel Linking (I think) 17
want to create a link to another worksheet in another workbook 1
Links not updated when primary worksheet is sorted 4
Deleting A Link (Source File) 1

Back
Top