Data linked to other workbooks

drewm · Apr 15th, 2002, 12:05 PM

I have a rather large workbook that when I open, gives the message that there are links to other workbooks, would I like to update them. There shouldn't be any links to other workbooks. If there are accidentally links, I really need to find them so as not to mess up my data. Is there any way to determine where these links might be?

Brian from Maui · Apr 15th, 2002, 12:19 PM

Try this

http://www.mrexcel.com/board/viewtop...c=4573&forum=2

EdE · Apr 15th, 2002, 12:20 PM

First thing is find out where they are linked to. Use Edit->Links. This will tell you the link. Then search on the keyword to see where the link is and delete it. Of course, I have come across the problem where I change from Link A to Link B and some of Link A still shows up where only B should be. The only way I have found around this is clearing the cell and reentering the information. Hope this helps.

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

Apr 15th, 2002, 12:05 PM	#1
drewm New Member Join Date: Apr 2002 Posts: 7	I have a rather large workbook that when I open, gives the message that there are links to other workbooks, would I like to update them. There shouldn't be any links to other workbooks. If there are accidentally links, I really need to find them so as not to mess up my data. Is there any way to determine where these links might be?

Apr 15th, 2002, 12:19 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Try this http://www.mrexcel.com/board/viewtop...c=4573&forum=2

Apr 15th, 2002, 12:20 PM	#3
EdE Board Regular Join Date: Apr 2002 Location: A Mile High!! Posts: 230	First thing is find out where they are linked to. Use Edit->Links. This will tell you the link. Then search on the keyword to see where the link is and delete it. Of course, I have come across the problem where I change from Link A to Link B and some of Link A still shows up where only B should be. The only way I have found around this is clearing the cell and reentering the information. Hope this helps.