View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mdwhite76 mdwhite76 is offline
external usenet poster
 
Posts: 1
Default RTD Server question

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