How do I determine which files are linked to my source file?
 

I need to know which excel workbooks are linked to an excel file that I want
to make changes to in order to avoid creating incorrect references once I
make the change. Is there a way to list all other excel files that are
linked to the excel file I want to alter?

How do I determine which files are linked to my source file?
 

Best to download Jan Pieterse's Name Manager Add-in which will do this and much
more.

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


Gord Dibben MS Excel MVP

On Thu, 13 Dec 2007 13:37:02 -0800, PackerinJax
wrote:

I need to know which excel workbooks are linked to an excel file that I want
to make changes to in order to avoid creating incorrect references once I
make the change. Is there a way to list all other excel files that are
linked to the excel file I want to alter?