MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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

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