How to find linked cells
 

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


--
anoop
------------------------------------------------------------------------
anoop's Profile: http://www.excelforum.com/member.php...fo&userid=3066
View this thread: http://www.excelforum.com/showthread...hreadid=480976

How to find linked cells
 

anoop Wrote:
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

Hi Anoop

Have a look at this, it may help

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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=480976