source file links

  • Thread starter Thread starter Tammy Engler
  • Start date Start date
T

Tammy Engler

How do I remove a link to a source file that is no longer
valid.

My file, when opened, asks "The workbook you opened
contains automatic links to information in another
workbook. Do you want to update this workbook with
changes made to the other workbook?...yes, no."

My file should not contain any links, but for some reason
asks this question.

How can I remove this link or delete the source file?
 
Links are a pain. You think you've removed them all but there could be one
or two lurking about. I use John Walkenbach's Power Utility Pak to hunt
them down. http://j-walk.com/ss/pup/pup5/index.htm . I got a free version
of the PUP on a CD-ROM included in one of my Excel books authored by John.
I believe there is a free trial version on his web-site. However, the
program is worth the $40 price if you do a lot of Excel work.

John
www.JohnMichl.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
Excel Protection 2
Deleting A Link (Source File) 1
External workbook links don't update when source file changes 1
linking workbooks when source data moves 1
Links not working in Excel 2007 2
Exterenal link 2
Link to another workbook path issue 1

Back
Top