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
1
vote
0 answers

Run a macro based on sample ID on RTD

I want to run the mail macro whenever cell B1 change. I need this to happen without manual intervention because B1 is changed due to incoming RTD(OPC) server data. As it stands, unless I manually update something in my sheet the macro does not…
曾博新
  • 11
  • 2
1
vote
3 answers

What does "Microsoft Office Excel is waiting for another application to complete an OLE action." mean?

I have a working RTD Excel automation add-in similar to the one described here. Intermittently, while attempting to load a sheet that includes this formula I get the following error: Microsoft Office Excel is waiting for another application to…
Frank
  • 3,029
  • 5
  • 34
  • 43
1
vote
1 answer

Count Cell Changes

Current script tracks cell changes from cell A1 and counts those changes in cell B1. However it only works when you actively input a number or text and then hit enter in cell A1. I need the formula to work when the A1 cell is referenced from another…
mjac
  • 125
  • 11
1
vote
1 answer

How to receive real-time data in excel using excel RTD and python?

I want to use excel as a front-end, which will continuously update multiple tables in real-time (every 2 seconds). I have a python program that prepares all the data tables, but it is running on some other server. I am storing python data in a Redis…
Krishna Kumar
  • 83
  • 14
1
vote
1 answer

Is it possible to build an Excel RTD Server that runs on MacOS using C# and .NET Core?

I want to buid an RTD Server that provides users with some market data. After some research I've learn that I can achieve that in Windows and .NET by implementing the IRtdServer interface located in the Microsoft.Office.Interop.Excel…
adamasan
  • 1,092
  • 1
  • 12
  • 33
1
vote
1 answer

Use Python to read RTD data from excel

I have an excel file with an external add-in which has a custom formula for accessing data from the client server. The data changes every 5 min and I need to keep track of updated data every 5 min. So, formula in an excel cell looks…
Zanam
  • 4,607
  • 13
  • 67
  • 143
1
vote
1 answer

Button to stop subs with OnTime Macro doesn't stop

I have a button assigned to the StopRecordingData sub to cancel both subs and it doesn't. The schedule False doesn't seem to cancel the scheduled subs in que. Dim NextTime As Double Sub RecordData() Dim Interval As Double Dim cel As Range,…
mjac
  • 125
  • 11
1
vote
3 answers

Workbook, Save, Close, Re-Open (w/ TimeValue),Repeat

The macro runs with a button assigned to "CloseMe". It used to run for my needs but doesn't anymore (as I tried using this code in another workbook without success). Now it saves, closes, waits 10sec to reopen, but then closes right away. Sub…
mjac
  • 125
  • 11
1
vote
1 answer

Exception when calling RTD server from Excel

I wrote a VSTO Excel addin using Visual Studio 2010 and after having managed to work around most of the obstacles Microsoft throws into the path of the righteous developer, I finally have to admit defeat. My project contains a Ribbon with some…
LeChe
  • 1,288
  • 14
  • 18
1
vote
1 answer

How to pool all RTD calls at excel startup?

I have an RTD server that gets the values from a realtime source. The problem is that the users have pretty large excel sheets close to 20,000 RTD formulas. So when the user opens the sheet, all the RTD formulas get fired resulting in sending 20,000…
Rashmi
  • 11
  • 1
1
vote
1 answer

Cannot debug C# RTD Server project in Visual Studio 2013

As part of an attempt to figure out the various issues working with (previously) working .NET COM projects and Excel 2013 on my machine, I created a simple test C# RTDServer class in Visual Studio 2013. Creating the test RTD Server project helped…
Sam Goldberg
  • 6,711
  • 8
  • 52
  • 85
1
vote
2 answers

Using RTD with Excel 2016 on Windows 10 Does Not Refresh

I'm trying to use RTD with Excel 2016 on Windows 10 and find that it does not refresh the values without a forced update using "Application.RTD.RefreshData" in the VBA Editor. I've tried several RTD servers and the problem appears common only to the…
AlexO
  • 99
  • 10
1
vote
1 answer

Running a code in Excel VBA whenever a cell with RTD-function is updated

I use VBA in MS Excel 2007 and I have cells with RTD-function that are updated every minute. My code is running just fine, but despite searching for an answer, I have not figured out how to make the code loop whenever new data are introduced in the…
forseti7
  • 11
  • 2
1
vote
1 answer

Excel RTD in VBA

I am trying to grab RTD output in VBA. The problem is it takes a couple seconds sometimes for the data to come back so when I run a loop half the time it incorrectly returns 0. Apparently RTD is running asynchronously. How can I set it to run…
CodeCamper
  • 6,609
  • 6
  • 44
  • 94
1
vote
1 answer

RTD equivalent for LibreOffice

Is there an LibreOfficeCalc function doing the same thing as RTD? I could not find one. Cheers
Gabriel
  • 3,564
  • 1
  • 27
  • 49
1 2
3
…
8 9