How to find linked cells

[anoop]

I am used to create excel files which has many cell reference from other
workbooks.
But after some time i forget that which cells are connected with other
workbook.

In Edit -> Links it is only showing the file names of other workbooks
but i am not able to find out which cells in current workbbok are
linked with other workbook.

How can i find out that which cells are connected with other
workbooks.?
Is there any output can i get which gives us information regarding
this.


Thanks.
Anoop

 

[Paul Sheppard]

I am used to create excel files which has many cell reference from othe
workbooks.
But after some time i forget that which cells are connected with othe
workbook.

In Edit -> Links it is only showing the file names of other workbook
but i am not able to find out which cells in current workbbok ar
linked with other workbook.

How can i find out that which cells are connected with othe
workbooks.?
Is there any output can i get which gives us information regardin
this.


Thanks.
Anoop

Hi Anoop

Have a look at this, it may help

http://www.oaltd.co.uk/MVP/Default.ht