Excel files linked to my file?

[TomYC]

The reverse of Edit, Links, which tells me which files my file "pulls" data from, or is linked with. I want to know: which files pull data from my file? Or: if my file has parent files, what are my file's child files?
I want to know this as I will soon need to move files, etc.

 

[macropod]

Hi Tom,

Other than going through all the files to which your file might be linked, there is no way to do this - MS Office files don't track what files link to them. When you think about it, trying to do so could be quite problematic: suppose a linking file gets deleted or moved to another folder - how is the source file supposed to know what's happened, especially if it's closed at the time?


Cheers
[MS MVP - Word]

 

[Gavona]

We are (about to be) in a similar situation following an organisational re-structure. I think that we need to think about how/whether to deal with:
a)Named ranges refering to another file
b)Links
c)Hyperlinks in outlook, excel and word files
d)File paths written into documents, emails that are not actually links

I have suggested that we take one of two approaches. Both approaches assume a lookup table of file path conversions (in our case it would mostly be the first part of the path that would change):
1. vba code to go through all files amending any links (issue that all the file modified dates get modified)
2. vba code made available to all users. They would initiate the macro that would search for and correct any links as the need arises.

Very interested in knowing how you resolve this - though I think that in depth discussion of the resolution will fit better in forum707.





Gavin

 

[kjv1611]

One idea, I think, is that if you are constantly linking to tons of individual Excel files, you'd be better suited instead storing all the data in a database, and then linking all the files to that one single database.

Whether that database be MS SQL, Access, MySQL, Oracle, etc, would depend upon your budget and needs, of course.

--

"If to err is human, then I must be some kind of human!" -Me