M
mdwhite76
Hello,
I'd like to create a RTD server in which the source and target are both
excel worksheets.
More specifically, I have one Excel worksheet (worksheet 1) stored on one
machine which contains data that is being updated from an external source -
real time. I want to create a RTD server that gathers data from worksheet 1,
and updates data on a second worksheet (worksheet 2), which is stored on a
separate machine.
I can't link the the sheets directly with data being updated realtime
because they are stored on 2 separate machines within a network. When I try
to open worksheet 2 after doing that, Excel asks me to "update the links".
That ends up only grabbing a snapshot of data from worksheet 1.
The 2 worksheets have to be on 2 separate machines because of certain
software limitations.
Can a RTD server be created to handle this? If so, how?
Any suggestions would be appreciated!
Thanks!!
I'd like to create a RTD server in which the source and target are both
excel worksheets.
More specifically, I have one Excel worksheet (worksheet 1) stored on one
machine which contains data that is being updated from an external source -
real time. I want to create a RTD server that gathers data from worksheet 1,
and updates data on a second worksheet (worksheet 2), which is stored on a
separate machine.
I can't link the the sheets directly with data being updated realtime
because they are stored on 2 separate machines within a network. When I try
to open worksheet 2 after doing that, Excel asks me to "update the links".
That ends up only grabbing a snapshot of data from worksheet 1.
The 2 worksheets have to be on 2 separate machines because of certain
software limitations.
Can a RTD server be created to handle this? If so, how?
Any suggestions would be appreciated!
Thanks!!