update data in workbooks through formula

[umba-sr]

I need to know if it is possible to copy data that I have stored in one
workbook, to another workbook, and update it in this other one every time
values or text change in a first one, just like I do it in single workbook
between sheets in formula bar.

Thanks

[bpeltzer]

Sure, the files would then be linked. Instead of =Sheet2!A1, your formula
would look like =[Book2.xls]Sheet2!A1. If you make changes in Book2, when
you open the file with this link in it, you'll get a prompt advising that
your workbook contains links and asking whether you want to update the data.
If you answer Yes, the links will be refreshed.

"umba-sr" wrote:

> I need to know if it is possible to copy data that I have stored in one
> workbook, to another workbook, and update it in this other one every time
> values or text change in a first one, just like I do it in single workbook
> between sheets in formula bar.
>
> Thanks

[Vellarian]

Hi,
sorry to add more question, but your answer is getting close to my problem,
I hope you can give me some advice..

What if I have file Book3.xls which linked to Book2.xls , and then I made
changes in Book1.xls.
Can I get the updated data when I open Book3.xls without having to open
Book2 ?
Is it possible for Excel to update its data without opening the "connection"
file as stored in Book2.xls?

Thank you so much for everything..


"bpeltzer" wrote:

> Sure, the files would then be linked. Instead of =Sheet2!A1, your formula
> would look like =[Book2.xls]Sheet2!A1. If you make changes in Book2, when
> you open the file with this link in it, you'll get a prompt advising that
> your workbook contains links and asking whether you want to update the data.
> If you answer Yes, the links will be refreshed.
>
> "umba-sr" wrote:
>
> > I need to know if it is possible to copy data that I have stored in one
> > workbook, to another workbook, and update it in this other one every time
> > values or text change in a first one, just like I do it in single workbook
> > between sheets in formula bar.
> >
> > Thanks