View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_2_] Gaurav[_2_] is offline
external usenet poster
 
Posts: 207
Default 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