Link to another file.

S

shcr

I have file A, which is used by several other files, All works ok.

Except, that say File B reads on Row 28, data from file A, row 32. When
I have to make a change in File A, as in adding/deleting rows, my other
files don't recognize that, and will then read incorrect data and I have to
change their links continually.

Is there anyway to keep this from happening?
 
M

mickedog

I'm not sure of any codes in vba, or even how to work with multi files.
I'm going to play with that when I get a chance.

but for an idea, could you name the ranges that are needed in you
formulas?

insert > name > define

i hope thats not a stupid idea )
 
F

Frank Kabel

Hi
only possible if both files are open while you delete/insert rows.
Otherwise no chance AFAIK
 
D

Dave Peterson

Besides using names (like mickedog wrote), you could keep the other workbooks
open when you adjust file A.

They'll see the change then and react nicely.
 
S

shcr

That worked! Will have to open multiple files, but easier that way than
remembering to change the formulas.

Thanks
 
Top