Linking question

kluitna · Mar 19th, 2002, 10:32 AM

I have several workbooks with links to other workbooks, Some of these links were create in the process of testing macros and such.

What I am trying to do now is remove those bad links. But I can not find where that is done at. I looked at edit links, and I can redirect links there and update them, but I don't see the option to just irradicate them. Anyone else ever had this problem?

Barrie Davidson · Mar 19th, 2002, 10:36 AM

Quote:

On 2002-03-19 09:32, kluitna wrote:
I have several workbooks with links to other workbooks, Some of these links were create in the process of testing macros and such.

What I am trying to do now is remove those bad links. But I can not find where that is done at. I looked at edit links, and I can redirect links there and update them, but I don't see the option to just irradicate them. Anyone else ever had this problem?

I have written some code to identify links. Have a look at:

http://ca.geocities.com/b_davidso/We...k_listing.html

If you need any help with implementing this just let me know.

Regards,

kluitna · Mar 19th, 2002, 10:53 AM

Thanks for the code Barrie, I can see where it will come in handy in the future as this monster I am creating grows.

My current project really does not have that many links in it. Its just hat I can't get rid of the ones I have. Its irritating me. My ultimate goal is to create a series of workbooks that are linked together. But here is the tricky part. They will be a template for other users, so I want the links only to be estabished after a end user has moved the template workbooks to there final destination. Then they just hit a tool bar button and wall la the links are established in the correct paths. I hace the code to do this now. It will work really slick. now my problem is getting rid of all the bogus links I created to figure out that code. SO I can have a clean copy of the workbooks. Anyone have any ideas

NateO · Mar 19th, 2002, 10:56 AM

If you want to browse the contents of your cells, press ctrl & ~ at the same time. this makes it easy to browse, replace, delete, etc...Press ctrl & ~ to get back to value view mode.

Hope this helps.

kluitna · Mar 19th, 2002, 11:10 AM

Helps allot Nate,

Thanks for all the help, to both you and Barrie, This is strating to make allot more sense now.

Mar 19th, 2002, 10:56 AM	#4
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	If you want to browse the contents of your cells, press ctrl & ~ at the same time. this makes it easy to browse, replace, delete, etc...Press ctrl & ~ to get back to value view mode. Hope this helps. __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

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

Mar 19th, 2002, 10:32 AM	#1
kluitna Board Regular Join Date: Mar 2002 Posts: 75	I have several workbooks with links to other workbooks, Some of these links were create in the process of testing macros and such. What I am trying to do now is remove those bad links. But I can not find where that is done at. I looked at edit links, and I can redirect links there and update them, but I don't see the option to just irradicate them. Anyone else ever had this problem?

Mar 19th, 2002, 10:53 AM	#3
kluitna Board Regular Join Date: Mar 2002 Posts: 75	Thanks for the code Barrie, I can see where it will come in handy in the future as this monster I am creating grows. My current project really does not have that many links in it. Its just hat I can't get rid of the ones I have. Its irritating me. My ultimate goal is to create a series of workbooks that are linked together. But here is the tricky part. They will be a template for other users, so I want the links only to be estabished after a end user has moved the template workbooks to there final destination. Then they just hit a tool bar button and wall la the links are established in the correct paths. I hace the code to do this now. It will work really slick. now my problem is getting rid of all the bogus links I created to figure out that code. SO I can have a clean copy of the workbooks. Anyone have any ideas

Mar 19th, 2002, 11:10 AM	#5
kluitna Board Regular Join Date: Mar 2002 Posts: 75	Helps allot Nate, Thanks for all the help, to both you and Barrie, This is strating to make allot more sense now.