Automatic Link

[AllenL]

Everytime I open my workbook, I get an automatic link message. The workbook doesn't relate to other workbook. Is there a way to disable the automatic link ???

Thanks in advance

 

[klb]

Try:

Tools, Options, Edit,
Uncheck the Ask to Update Automatic Links


Also, check the name ranges in your workbook to see if they refer to another workbook.

 

[AllenL]

I tried that and it didn't show the message anymore.
However, because I deleted all the linked files, I got a file not found window when I open the workbook.
Is there a way to solve this problem???
Thanks again

 

[heather]

I don't have a quick solution, but the same thing happened to me when I took over a project for someone. I saved the file as something else and started to delete worksheet by worksheet (saving, and reopening) to see if it solved the problem. I was able to locate which sheet had the link and was able to eliminate it from there. It isn't the best solution, but it worked.

 

[AllenL]

Thanks
I will try that tomorrow.

 

[Mark W.]

You may find that these links are not the result of formulas entered into worksheet cells (which should be easy to find once you refuse to update links), but rather references in Defined Names. Take a look at those too! The ASAP Utilities suite (see www.asap-utilities.com.) which is a free add-in includes an Information command that lists all Range names and their referrals. You might find it useful.
This message was edited by Mark W. on 2002-04-18 13:25

 

[AllenL]

Hello Mark or anyone
If I don't have the Asap utility, how can I find the reference of the Defined Name?
After I find the reference, what should I do next to disable the automatic linked list?
Thanks in advance

 

[Ricky Morris]

I have written a utility that will delete links to other workbooks. Let me know if you're interested and I'll send it to you.

 

[AllenL]

Hello Ricky
yes
I will be very appreciated if you could send me a copy of the utility to visitliu@hotmail.com
Thanks in advance