Automatic Link

AllenL · Apr 18th, 2002, 08:43 AM

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 · Apr 18th, 2002, 08:51 AM

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 · Apr 18th, 2002, 09:14 AM

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 · Apr 18th, 2002, 11:22 AM

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 · Apr 18th, 2002, 02:05 PM

Thanks
I will try that tomorrow.

Mark W. · Apr 18th, 2002, 02:21 PM

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 · Apr 22nd, 2002, 01:36 PM

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 · Apr 22nd, 2002, 01:39 PM

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 · Apr 22nd, 2002, 01:46 PM

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

Apr 22nd, 2002, 01:39 PM	#8
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	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. __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 08:43 AM	#1
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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

Apr 18th, 2002, 08:51 AM	#2
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	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.

Apr 18th, 2002, 09:14 AM	#3
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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

Apr 18th, 2002, 11:22 AM	#4
heather New Member Join Date: Apr 2002 Posts: 8	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.

Apr 18th, 2002, 02:05 PM	#5
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Thanks I will try that tomorrow.

Apr 18th, 2002, 02:21 PM	#6
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	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 ]

Apr 22nd, 2002, 01:36 PM	#7
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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

Apr 22nd, 2002, 01:46 PM	#9
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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