Stack Overflow
Stack Overflow

Questions tagged [rtd]

RTD (Real Time Data) is a feature introduced with Excel 2002 to display data provided by an RTD server. For questions regarding real-time data outside Excel choose the tag 'real-time-data'.

RTD (Real Time Data) is a feature that has been introduced with Excel 2002. It provides the ability to display data in real time within the sheet. The data is provided by a so-called RTD server (not to be confused with a hardware server), which is an external program that binds through an IRTD interface that's based on COM interaction.

124 questions
0
votes
1 answer

How ODBC connect to SQL Anywhere 12

I'm using sqlAnywhere 5.0 to create ODBC with third parties software house I'm running it on windows XP without any error / problem but 8/4/2014 Microsoft announce to stop service for windows XP then our company migrate all client PC to windows…
user3354223
  • 1
0
votes
1 answer

RTD.RefreshData crashes when invoked from modal form

I have created a very simple modal form with two buttons: one just closes the form, and the other calls Application.RTD.RefreshData. In Excel 2003 this all works just fine, but in Excel 2010 the Application.RTD.RefreshData crashes with Run-time…
atkins
  • 1,963
  • 14
  • 27
0
votes
1 answer

rtd/mirror_app does not work as expected with Meteor.loginWithGoogle

I've published a Meteor code example similar to githublogin but for Google login process (https://github.com/lc3t35/googlelogin, How to get Google+ profile with Meteor.loginWithGoogle?), it works fine so i decided to add unittests with rtd on this…
Laurent Roger
  • 198
  • 1
  • 9
0
votes
0 answers

Refresh a worksheet during a long run RTD request in Excel

I am working in C# on an Excel AddIn with ExcelDNA. I have an Excel worksheet with a UDF placed in a lot of cells as a "formula array" making an RTD request. Since the request is huge, it is divided in several threads. Therefore the responses…
Mr.Pe
  • 719
  • 1
  • 7
  • 19
0
votes
1 answer

C# Excel 2007 RTD Server crashes on exit

I have written a c# RTD server based off of Kenny Ker's Multiple Topics in C# The main difference between his design and mine is that my data comes from a WCF client. I use the same type of timer and every couple of seconds I call…
MarkB42
  • 725
  • 9
  • 23
0
votes
0 answers

Excel UDF in XLL RTD edit causes formula to lose correct topic

I am building XLL + RTD in the same dll. The RTD is not called directly from Excel but through wrapper formula. Similar to sample here Custom Functions in Excel: Part V, XLL-RTDs The functionality seems to be working but when I edit formula inputs…
SparcU
  • 742
  • 1
  • 7
  • 27
0
votes
1 answer

Is it possible to use the same RTDServer in multiple excel instances

I have a C# RTDServer that works well in one instance of excel. It is defined as follows: [Guid("1D50EF28-A1BE-4BE9-9214-46A48085ADFF")] [ProgId("Acme.RtdServer")] public class RTDServer : IRtdServer { // IRtdServer members: // ... } When the…
Pat Mustard
  • 1,852
  • 9
  • 31
  • 58
0
votes
1 answer

EXCEL application updating event

Most of the cells in my worksheet receives RTD data once per second and a lot of calculations are done when the data is refreshed. It's becoming really slow. If I set Application.ScreenUpdating to false, does it mean even if the most recent data is…
user511792
  • 489
  • 1
  • 13
  • 23
0
votes
1 answer

IRtdServer.RefreshData and format cell

Can RefreshData function send Excel cell format information. I want excel to show arrows in his cells and I want RTD server to inform him which arrow to show.
Vasoli
  • 77
  • 7
0
votes
1 answer

add Excel RTD Server project type in visual studio

I will like to create something similar to: http://www.add-in-express.com/docs/net-excel-rtd-servers.php When I open visual studio I do not have that project type even though I am running it as an administrator... what do I have to do so that I can…
Tono Nam
  • 34,064
  • 78
  • 298
  • 470
0
votes
1 answer

C# COM client (RTD)

I'm working with a real time data server (a trading terminal) that has a COM interface for ticker updates. From Excel, I'm able to subscribe to the ticker updates using this - RTD(progId,,topic1,topic2, ...) I'm trying to build an application that…
Vivek
  • 111
  • 2
  • 10
0
votes
1 answer

Module Function in Excel Returns #VALUE

I have an RTD server that I am using to send data to and from Excel. I am trying to make it easier on the user by building a few simple functions in a Module in Excel's VBA to allow for them to grab data without knowing the whole backend. …
JamesD31
  • 165
  • 1
  • 2
  • 10
0
votes
1 answer

Excel Freezes With RTD Call

So, this used to never happen before and now it is doing it every single time. The RTD server is off now for testing purposes and there is nothing that the Excel really has to do but spit out #N/A. The weird thing is it works fine and fails with the…
JamesD31
  • 165
  • 1
  • 2
  • 10
0
votes
2 answers

what is default throttle value for Excel 2010

I see from http://msdn.microsoft.com/en-us/library/aa140060(v=office.10).aspx that data throttle value for Excel 2002 is 2 seconds. but I can't find the default value for Excel 2003, 2007 & 2010. I assume they are 2 seconds, too. But just want to…
toosensitive
  • 2,335
  • 7
  • 46
  • 88
-1
votes
1 answer

Array Difference IF/OR VBA Script

Have script that stores an array and if it changes it finds the difference. Now I need it to take that difference and check against if the adjacent cell is "John or Mary" and times the array value difference by: (If "John" = Array Value Diff. *…
mjac
  • 125
  • 11
1 2 3
…
8
9