If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Running mutiple excel sheets on mutiple computers
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. |
#3
|
|||
|
|||
Running mutiple excel sheets on mutiple computers
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. |
#4
|
|||
|
|||
Running mutiple excel sheets on mutiple computers
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. |
Thread Tools | |
Display Modes | |
|
|