How to find linked cells

A

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
 
P

Paul Sheppard

anoop said:
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
Click to expand...

Hi Anoop

Have a look at this, it may help

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