Link to another file.

  • Thread starter Thread starter shcr
  • Start date Start date
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?
 
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 )
 
Hi
only possible if both files are open while you delete/insert rows.
Otherwise no chance AFAIK
 
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.
 
That worked! Will have to open multiple files, but easier that way than
remembering to change the formulas.

Thanks
 
Back
Top