Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
Query from ms sql server question | Excel Programming | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) |