Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I find what files link into a source file in Excel? KWBPAB Excel Worksheet Functions 1 May 21st 07 04:25 PM
How to update destination file with source files closed? Alex Costache Excel Discussion (Misc queries) 2 August 1st 06 10:08 AM
Linked File Calcuation req. source file to be open smcd Excel Discussion (Misc queries) 1 April 19th 06 03:09 AM
linked values not displayed unless source file open Sandyc Excel Discussion (Misc queries) 1 October 7th 05 02:18 PM
Excel '02: does it allow source files (linked cells) to be opened. RAS Excel Discussion (Misc queries) 1 December 8th 04 11:49 PM


All times are GMT +1. The time now is 12:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"