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!!