Find External Links
 

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

Find External Links
 

oh got it. Editlinks

Thanks for reading it though.


"Gaurav" wrote in message
...
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

Find External Links
 

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

Gaurav wrote:

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

--

Dave Peterson