listing cells that have external data link

T

T-Rex

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
 
D

Dave Peterson

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

T-Rex

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
Click to expand...
Click to expand...
 
Top