Finding links to other workbooks

TradeFederation · May 22nd, 2002, 01:22 PM

When I open up one of my workbooks, it gives me the message that I have links to other workbooks and asks if I would like to update them now.

I did not create this particular workbook and I am sure that whatever data is being linked in is not necessary. I would like to find the cells where these links are and get rid of them to eliminate that message box coming up all the time.

The problem is that I can't find the cells! I have encountered this problem in the past, and have always been able to select all sheets and search for the string ".xls" in the formulas to find the link. This isn't working this time. Any ideas how to find these cells????

Thanks!!

Gary_E · May 22nd, 2002, 02:00 PM

There's a greate add-in - the can be accessed via Chip Pearson's web site -
It's named LinkFind - by Bill Manville.

http://www.cpearson.com/excel/xltools.htm

Check the range names for links (global & sheet lvl) -
Any hidden tabs ?

_________________
Thxs for tips - this place is a great source
tips & tricks

G_L

[ This Message was edited by: Gary_E on 2002-05-22 13:17 ]

Al Chara · May 22nd, 2002, 05:19 PM

You can also try doing the following:

Edit|Links...

May 22nd, 2002, 05:19 PM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	You can also try doing the following: Edit\|Links... __________________ Kind regards, Al Chara

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

May 22nd, 2002, 01:22 PM	#1
TradeFederation New Member Join Date: May 2002 Posts: 1	When I open up one of my workbooks, it gives me the message that I have links to other workbooks and asks if I would like to update them now. I did not create this particular workbook and I am sure that whatever data is being linked in is not necessary. I would like to find the cells where these links are and get rid of them to eliminate that message box coming up all the time. The problem is that I can't find the cells! I have encountered this problem in the past, and have always been able to select all sheets and search for the string ".xls" in the formulas to find the link. This isn't working this time. Any ideas how to find these cells???? Thanks!!

May 22nd, 2002, 02:00 PM	#2
Gary_E Board Regular Join Date: Feb 2002 Location: Charlotte, NC USA Posts: 108	There's a greate add-in - the can be accessed via Chip Pearson's web site - It's named LinkFind - by Bill Manville. http://www.cpearson.com/excel/xltools.htm Check the range names for links (global & sheet lvl) - Any hidden tabs ? _________________ Thxs for tips - this place is a great source tips & tricks G_L [ This Message was edited by: Gary_E on 2002-05-22 13:17 ]