How can I remove "links to external workbooks"

[shadestreet]

I have a workbook that used to pull information from a separate exce
file, but now those links are removed. However, when I open thi
workbook it still gives me the message "would like to update with link
to external workbooks". How can I remove these messages permamently?

Also, if I do in fact have links to other workbooks somewhere in th
file, how can I locate these cells?

Thanks

 

[Frank Kabel]

Hi
the following add-in will help you to delete these links
http://www.bmsltd.ie/DLCount/DLCount.asp?file=FindLink.zip

 

[shadestreet]

Thanks Frank, but my computer isn't accepting that add-in unfortunatel
I get this message:

Virus report (handford)
Virus was found and deleted i
http://www.bmsltd.ie/Spreads/FindLink.zip:
Found virus MacroStripped in file findlink.xla (in FindLink.zip)

The uncleanable file is deleted.

Any other ideas

 

[Frank Kabel]

Hi
I doubt that there's a macro included in this file. You may either tell
what you're trying to do (as your first post did not provide much
information) Or contact the webmaster of this site:
http://www.bmsltd.ie)

 

[Frank Kabel]

Hi
Of course I doubt that there's a VIRUS in this file

--
Regards
Frank Kabel
Frankfurt, Germany

Hi
I doubt that there's a macro included in this file. You may either tell
what you're trying to do (as your first post did not provide much
information) Or contact the webmaster of this site:
http://www.bmsltd.ie)

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag news:[email protected]...

 

[Ken Wright]

Bill's addin works fine for me, and scans clean with AVG.

 

[shadestreet]

Looking at steve's site, I cant find the Add-in you are suggesting, and
the URL is still blocked because of the error message by my corporate
ISP.

To be more clear with my original question, I was just curious if there
is a method to make your workbook realize it no longer has links to
external files.

If I made a cell reference a separate file at any point, but later
deleted that reference, the Excel file will always seem to think I am
still lnking to external workbooks. Just curious if there is a way to
fix this.

Thanks,

 

[Ken Wright]

Depending on the version you have you can use Edit / Links / Break Links

If you want Bill's addin then I'll happily mail it to you if you so wish. This
will identify the links and tell you where they are, as well as give you options
for dealing with them should your version of Excel not support the feature I
mentiond earlier.

 

[shadestreet]

I am using Office 2000, and when I go to Edit > Links I get a dialog box
that allows me open the source or choose a new source. Don't think I
can disable the external links.

Would you mind emailing me the Add-in?

(e-mail address removed)

Thanks

 

[Dave Hawley]

Hi,

This link normally fixes the problem.

http://www.ozgrid.com/Excel/ExcelProblems.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Ken Wright]

On it's way