Then click the find all button. You'll see a list of all those cells that
contain that value--and if you're not using them as plain old text, you should
see a list of links.
Dave
Thanks...works like a charm after I set Find to search for the complete
workbook
Rex
Dave Peterson said:
Maybe you could use the builtin edit|Find.
Search for .xls (or [ or ]
Then click the find all button. You'll see a list of all those cells that
contain that value--and if you're not using them as plain old text, you should
see a list of links.
T-Rex said:
I bet this has been asked before... Is there a way or a tool to list all
cells that are linked to external data sources?
Using Excel 2002
Rex
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.