Archive of Mr Excel Message Board


Back to Links in Excel archive index
Back to archive home

Finding a Link in Excel 97

Posted by Jose Antonio Gonzalez on August 28, 2001 3:45 AM
Hello all!

I am unable of finding the cell that contains a link in one of my sheets. The only way to delete the link is to delete the sheet because nor deleting all the cells neither clearing all contents work. And of course the find tool does not find nothing.

I can find this tool but it is a commercial solution http://www.add-ins.com/linkfind.htm

Any idea?

Thnak you


Re: Finding a Link in Excel 97

Posted by Barrie Davidson on August 28, 2001 7:04 AM

Jose, have you tried checking your defined names? I'll bet you've got a name defined that refers to another spreadsheet.

Regards,
Barrie


Re: Finding a Link in Excel 97

Posted by Jose Antonio Gonzalez on August 29, 2001 1:35 AM
Barry, your bet wins!


Thanks a lot


--
Jose Antonio Gonzalez
Controller
Hotel Maria Cristina RES 086 - FRS 347 - SAP F220


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.