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

's Computer Specifications

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?

's Computer Specifications

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
<(E-Mail Removed)> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word2003 changing multiple linked source files at once	dbeachy	Microsoft Word Document Management	1	11th Aug 2009 04:05 PM
Verifying linked table source files exist	Walt H	Microsoft Access VBA Modules	2	15th May 2008 07:35 PM
Linked File Calcuation req. source file to be open	smcd	Microsoft Excel Misc	1	19th Apr 2006 03:09 AM
Excel '02: does it allow source files (linked cells) to be opened.	=?Utf-8?B?UkFT?=	Microsoft Excel Misc	1	8th Dec 2004 11:49 PM
changing source files for linked objects	=?Utf-8?B?cmVuZWU=?=	Microsoft Word Document Management	1	16th Oct 2004 04:02 AM