removing automatic link
 

Hi,

I got an issue about excel link. I did search and find this posting.
Firstly, Bill's Add-in is really useful.
But after run it, I still have the problem here.
When I get to Edit/Link, it shows there is link called "Adj", but no any
location info for this link.
then I ran 'Find Link' , all the link regarding 'Adj' are those one which
links between the sheets within this file, no any with out source file.

So everytime I open file, it always prompt to ask update or don't update
for link with the out source file.

Is there anyone have an idea about this issue? Why the link within the
file is got listed in "links" and prompted to ask update? Or is there any
hidden link here?

Any idea would be appreciated

xk





"David McRitchie" wrote:

Before or after installing it ?

To install first unzip the file into a folder. If you don't have a program
to unzip then you can get one free for home use here
http://www.ultimatezip.com

There will probably be instructions, if not, Tools, Addins, but you will have an .xla file
which you can install by going to Tools, Addins, Browse button
to locate your addin. If you put your addin in one of the folders indicated in
the help for the the Browse button is would already be listed, check the box
and your addin is installed.

I believe the initial find is set up for #REF! which is a broken link
print appropriate button. I think there is the ability to look at a summary
listing rather than anwering to delete each link or not as encountered.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Billing Goddess" <Billing wrote in message
...
Thank you, but I am not sure how this add in works? Can you assist?

"Frank Kabel" wrote:

Hi
try the following add-in to find/delete links:
http://www.bmsltd.ie/DLCount/DLCount...e=FindLink.zip

--
Regards
Frank Kabel
Frankfurt, Germany


Billing goddess wrote:
Is there a way in Office 2000 that a link between two workbooks can
be removed? I know in 2003, when you click on edit/link you can
remove the link, but i cannot locate the function in office 2000...