LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server -- Bulk Insert from Excel to SQL Server Madhan Excel Discussion (Misc queries) 0 December 12th 06 03:08 PM
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server Seabee Excel Discussion (Misc queries) 0 November 20th 05 12:03 AM
Query from ms sql server question canix[_2_] Excel Programming 2 August 10th 05 06:47 PM
problem updating link from Novell server to windows server #REF er Ellen Excel Discussion (Misc queries) 0 May 10th 05 09:18 PM


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"