Find External Links

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gaurav - 10 Mar 2008 20:47 GMT

Hi,

Is there an easy way to find which cells have a formula with links to
external workbook/s?

I have a workbook with over 20 sheets. When I open it does give me the
pop-up saying 'this workbook has links to other data sources' but i am
unable to find it. 'Go-To' finction doesnt help because all the sheets are
full of formulas.

Help would be appreciated.
Thanks

Reply to this Message

Gaurav - 10 Mar 2008 20:54 GMT

oh got it. Edit>links

Thanks for reading it though.

> Hi,
>
[quoted text clipped - 8 lines]
> Help would be appreciated.
> Thanks

Reply to this Message

Dave Peterson - 10 Mar 2008 23:43 GMT

You may want to get Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

> Hi,
>
[quoted text clipped - 8 lines]
> Help would be appreciated.
> Thanks

Signature

Dave Peterson

Reply to this Message