Real time data server

Hi,
I need to build RTD server in excel. That mean I need in one cell actual time, which could be updating every 0.1 second.
I tried function =NOW() cell format mm:ss,0 but update is only when I press or hold F9 (for recalc)
Then I tried this http://msdn.microsoft.com/en-us/libr...ffice.10).aspx
Part -> The Now & Today RTD Server
I downloaded RTDTime.dll and did all what was in the article written.
now in my cell is automatic updating actual time, but it is every 2 - 3 seconds, not every 0.1 second.
Thanks for some help.

I may be wrong here (forum regulars please correct me if so), but I don't think you'll be able to get Excel to update that fast. It just wasn't meant for that. Of course, it depends on how much data you're going to serve. IIRC, Excel can't update the value in the time cell until all the changes that the previous update caused have been processed. Perhaps all of that takes 2-3 seconds?

Excel + VBA was never meant for time-critical applications. That's where databases and "real programming languages" usually come into play. And then you still need to be quite sure your computer doesn't have a 1 sec. hickup when you connect a new hardware device, or do something that requires lots of CPU. meaning you'll have to give your program top priority, so other programs are not allowed to take it's CPU usage.

I think you seriously have to reconsider using Excel + VBA here. Of course, I'll keep an eye on this thread to see what others think about it.

Good luck!

Jacco

I tried this:

How Do I Configure the RTD Throttle Interval In Excel?

This can only be modified via the Excel object model or the registry. There is no user interface for configuring the RTD throttle interval in Excel.

* If the RTD throttle interval is set to -1, this is considered manual mode, and Excel only checks for updates when Excel.Application.RTD.RefreshData is called.
* If the RTD throttle interval is set to zero, Excel checks for updates every chance it gets.
* If the RTD throttle interval is set to something greater than zero, Excel waits at least that number of milliseconds between checks for updates.

Caution If updates come in so frequently that Excel is continuously updating values and doing calculations, Excel might end up in a state where it never gives the user a chance to do anything, effectively getting in a hung state. If this happens, set the Excel throttle interval higher.

To set the throttle interval higher through the Excel object model:

1. In Excel, go to the Visual Basic Editor (by pressing ALT+F11 or clicking Visual Basic Editor from the Macro menu (Tools menu)).
2. In the Immediate window (press CTRL+G or click Immediate Window on the View menu), type this code:
Application.RTD.ThrottleInterval = 1000
3. Make sure your cursor is on the line that you just typed, and then press ENTER.
4. To verify that it is set correctly, type this line of if code in the Immediate window:
? Application.RTD.ThrottleInterval
5. If you put your cursor at the end of this line and press ENTER, it should display 1000. Then you know that your throttle interval is set correctly.
...................
If I set it to 1000 or lower, excel is updating every second, but I still need every 1/10 second :/

try setting it to 100