Throttle RTD Interval

How to throttle the RTD interval

By default, Microsoft Excel will throttle RTD updates into your spreadsheet. This means that data can be delayed, especially if you are expecting multiple updates per second.

To check your current RTD throttle interval, follow these steps:

  • Open the Visual Basic editor using Alt + F11
  • Open the Immediate Window using View->Immediate Window or Ctrl + G
  • Type into the immediate window, “?Application.RTD.ThrottleInterval” (without the quotes) and press Enter

The default value for Excel is 2000 milliseconds or 2 seconds, which means that updates will not be refreshed within 2 seconds of each-other in your sheet.



How to change the RTD interval

You can set a new value for the RTD throttle interval in the same immediate window as above, using the following syntax:

Application.RTD.ThrottleInterval=1000

which would set the throttle to 1 second.

To remove the throttle completely, and have Excel send updates as quickly as it can to your spreadsheet, you can turn it off with

Application.RTD.ThrottleInterval=0

Posted in Excel + VBA Tips.

20 Comments

  1. Its like you read my mind! You appear to know so much
    about this, like you wrote the book in it or something.
    I think that you can do with a few pics to drive the message home a bit, but instead of that, this is wonderful
    blog. A great read. I’ll certainly be back.

  2. Please let me know if you’re looking for a article writer for your
    weblog. You have some really great articles and I believe I
    would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write
    some articles for your blog in exchange for a link back to mine.
    Please send me an e-mail if interested. Thanks!

  3. Does your website have a contact page? I’m having trouble locating it
    but, I’d like to shoot you an email. I’ve got some suggestions for your blog you might be interested in hearing.
    Either way, great blog and I look forward to seeing it improve over time.

  4. I know this if off topic but I’m looking into starting my own weblog and was curious what all is needed to get setup?
    I’m assuming having a blog like yours would cost a pretty penny?
    I’m not very web savvy so I’m not 100% sure. Any recommendations or advice
    would be greatly appreciated. Cheers

  5. Hi! I know this is kinda off topic nevertheless I’d figured I’d ask.
    Would you be interested in trading links or maybe guest authoring
    a blog article or vice-versa? My blog covers a lot of the same
    topics as yours and I believe we could greatly benefit from each other.
    If you’re interested feel free to send me an email.
    I look forward to hearing from you! Fantastic blog by the
    way!

  6. Today, I went to the beach with my kids. I found a sea shell and
    gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She placed the
    shell to her ear and screamed. There was a hermit crab inside and it pinched her ear.
    She never wants to go back! LoL I know this is entirely off topic
    but I had to tell someone!

  7. I was wondering if you ever considered changing the layout of your blog?
    Its very well written; I love what youve got to say. But maybe you could a
    little more in the way of content so people could connect with
    it better. Youve got an awful lot of text for only having one or two images.
    Maybe you could space it out better?

  8. Excellent goods from you, man. I’ve understand your stuff previous to and you are just too wonderful.
    I actually like what you have acquired here, certainly like what
    you’re saying and the way in which you say it.
    You make it enjoyable and you still care for to keep it sensible.
    I can’t wait to read much more from you. This is really a
    wonderful site.

  9. Pretty component to content. I just stumbled upon your website and
    in accession capital to claim that I acquire actually enjoyed account your blog posts.

    Any way I will be subscribing for your feeds and even I success you get admission to persistently rapidly.

Leave a Reply to instagram takipci satin al Cancel reply

Your email address will not be published. Required fields are marked *