I have a workbook (actually a few!) that contain links to other workbooks
that I know it shouldn't. I've tried using 'find' to locate the cells which
contain these filenames in but it comes back 'text not found'. I can't find
any hidden cells either.

These workbooks do contain other links that should be there, I suspect that
these links have found their way into the workbook by being copied and pasted
from another workbook.

Does anyone have any ideas on how I can find these stray links?

Thanks
Pat

hi,
try this keyboard thing.

ctrl + ~

This will take you to formula edit mode and show all forumlas (and Links) as
they appear in the formula bar. It will show all data too but the links and
formulas will have an equal sign in front of it.

Press ctrl + ~ again to get out of edit mode.

regards
FSt1

"Pat van Aalst" wrote:

I have a workbook (actually a few!) that contain links to other workbooks
that I know it shouldn't. I've tried using 'find' to locate the cells which
contain these filenames in but it comes back 'text not found'. I can't find
any hidden cells either.

These workbooks do contain other links that should be there, I suspect that
these links have found their way into the workbook by being copied and pasted
from another workbook.

Does anyone have any ideas on how I can find these stray links?

Thanks
Pat

Orphaned Links -- HELP!
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Search the forum, chances are the question has been asked before,


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=518640

Check out the FindLink Add-in by Bill Manville....

http://www.oaltd.co.uk/mvp/

Vaya con Dios,
Chuck, CABGx3



"Pat van Aalst" wrote:

I have a workbook (actually a few!) that contain links to other workbooks
that I know it shouldn't. I've tried using 'find' to locate the cells which
contain these filenames in but it comes back 'text not found'. I can't find
any hidden cells either.

These workbooks do contain other links that should be there, I suspect that
these links have found their way into the workbook by being copied and pasted
from another workbook.

Does anyone have any ideas on how I can find these stray links?

Thanks
Pat