find linked cells?

Is there a way to automatically find all links in cells
where they are linked to another workbook? Not just Edit -
Links to see which workbook, but to actually find the
cells either one by one or all at once automatically. I
know Edit Find - [ will work but there must be a better
way?

Want to look at over 100 workbooks and find their links
and investigate any problem links etc.

Ta
Sall

Sallyt wrote:
Is there a way to automatically find all links in cells
where they are linked to another workbook? Not just Edit -
Links to see which workbook, but to actually find the
cells either one by one or all at once automatically. I
know Edit Find - [ will work but there must be a better
way?

FINDLINK.XLA from http://www.BMSLtd.ie/mvp
will find the links in an individual open workbook.

I also have a utility (LinkManager) which will scan all workbooks in a
directory - email me at Bill_Manville @ compuserve.com (without the
spaces) if you want a copy.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Very many thanks Bill. Just wanted to know whether you
could do it without any extra downloads. Thanks for
replying!
Sally T


-----Original Message-----
Sallyt wrote:
Is there a way to automatically find all links in cells
where they are linked to another workbook? Not just
Edit -
Links to see which workbook, but to actually find the
cells either one by one or all at once automatically.
I
know Edit Find - [ will work but there must be a
better
way?

FINDLINK.XLA from http://www.BMSLtd.ie/mvp
will find the links in an individual open workbook.

I also have a utility (LinkManager) which will scan all
workbooks in a
directory - email me at Bill_Manville @ compuserve.com
(without the
spaces) if you want a copy.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

.