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, Excel to Excel connection


Hello,

I'd like to create a RTD server in which the source and target are bot
excel worksheets.

More specifically, I have one Excel worksheet (worksheet 1) stored o
one machine which contains data that is being updated from an externa
source - real time. I want to create a RTD server that gathers dat
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 realtim
because they are stored on 2 separate machines within a network. Whe
I try to open worksheet 2 after doing that, Excel asks me to "updat
the links". That ends up only grabbing a snapshot of data fro
worksheet 1.

The 2 worksheets have to be on 2 separate machines because of certai
software limitations.

Can a RTD server be created to handle this? If so, how?

Any suggestions would be appreciated!

Thanks!

--
mdwhit
-----------------------------------------------------------------------
mdwhite's Profile: http://www.excelforum.com/member.php...nfo&userid=162
View this thread: http://www.excelforum.com/showthread.php?threadid=53891

 
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
Excel VBA connection to SQL Server using ADO Taolo Morake Excel Programming 0 September 26th 05 04:06 PM
ADO Connection to SQL Server [email protected] Excel Programming 3 August 3rd 05 12:29 PM
ADO connection problem when using server Bkraska Excel Programming 7 March 18th 05 02:15 PM
ado connection to access vs. sql server? Loane Sharp Excel Programming 7 November 16th 04 05:08 PM
sql server connection Andy Wiggins[_3_] Excel Programming 0 January 27th 04 08:40 AM


All times are GMT +1. The time now is 06:29 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"