View Single Post
  #2   Report Post  
Paul Sheppard
 
Posts: n/a
Default 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