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

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

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