Running mutiple excel sheets on mutiple computers

Ok I am running 4 computers with 4 different workbooks. Then I have a 5th
workbook that is supposed to pull data from all 4 sheets. This works when I
have all the sheets open on one computer but when I use multiple computers it
doesnt work. All the workbooks are in the same folders on a networked shared
drive. Im kinda new to this so if there are ideas out there they would be
helpful

Thanks

Lost wrote:
Ok I am running 4 computers with 4 different workbooks. Then I have a 5th
workbook that is supposed to pull data from all 4 sheets. This works when I
have all the sheets open on one computer but when I use multiple computers it
doesnt work. All the workbooks are in the same folders on a networked shared
drive. Im kinda new to this so if there are ideas out there they would be
helpful

Thanks

What exactly doesn't work? What (formula) are you using to get data from
external workbooks? What is the error?

IME, some formulae do not work with linked workbooks unless the source
book is open locally.

Ok I think I have it figured out but im using alot of If and, sum if and, and
Vlookups. The majority of the formulas have over 300 characters so I use '07
to program and they use '03 while running the sheets on the production floor.
I dont get any errors within the cells but I also dont get the information
its supposed to be pulling either. I have autoupdate selected for all sheets
but im lost lol. Im new to excel learning as i go. But what I need the
sheets to do is up date real time like they do when I use one computer while
running multiple computers. Is this even possible?


"smartin" wrote:

Lost wrote:
Ok I am running 4 computers with 4 different workbooks. Then I have a 5th
workbook that is supposed to pull data from all 4 sheets. This works when I
have all the sheets open on one computer but when I use multiple computers it
doesnt work. All the workbooks are in the same folders on a networked shared
drive. Im kinda new to this so if there are ideas out there they would be
helpful

Thanks

What exactly doesn't work? What (formula) are you using to get data from
external workbooks? What is the error?

IME, some formulae do not work with linked workbooks unless the source
book is open locally.

AFAIK, no, can't do real time update unless all the source sheets are
open locally. I could be wrong.

Failing that it might be possible to write some VBA to force linked
values to update on a timer.

Lost wrote:
Ok I think I have it figured out but im using alot of If and, sum if and, and
Vlookups. The majority of the formulas have over 300 characters so I use '07
to program and they use '03 while running the sheets on the production floor.
I dont get any errors within the cells but I also dont get the information
its supposed to be pulling either. I have autoupdate selected for all sheets
but im lost lol. Im new to excel learning as i go. But what I need the
sheets to do is up date real time like they do when I use one computer while
running multiple computers. Is this even possible?


"smartin" wrote:

Lost wrote:
Ok I am running 4 computers with 4 different workbooks. Then I have a 5th
workbook that is supposed to pull data from all 4 sheets. This works when I
have all the sheets open on one computer but when I use multiple computers it
doesnt work. All the workbooks are in the same folders on a networked shared
drive. Im kinda new to this so if there are ideas out there they would be
helpful

Thanks
What exactly doesn't work? What (formula) are you using to get data from
external workbooks? What is the error?

IME, some formulae do not work with linked workbooks unless the source
book is open locally.