Any way to tell Excel to disregard all other calculation processes EXCEPT a certain one (or at least give priority to the newest one)?

[d0rian]

My file uses an API to pull in 500+ streaming stock-quotes -- once the connection has been established and they're being pulled in, they update rather quickly BUT the initial API call to the stock data provider's service often takes over a minute...I suspect it's because I've got a bunch of other calculations going on in the workbook (live sorting, INDEX/MATCH lookups, etc). Is there any way for me to tell Excel: "I want you to turn off all calculations in this workbook EXCEPT for those in range XYZ...or at least pause all others until this one's done processing? (I've tried setting Calculation to Manual (for the entire file), but it appears that the API call needs calculations on in order to pull in the stock quotes, so that doesn't help me with the initial population...)

 

[jkpieterse]

You can disable/enable calculations per worksheet, would that help?

ActiveSheet.EnableCalculation = False

 

[d0rian]

Hm...possibly, I'll give it a try. But -- switching gears for a moment -- is there any way to give 'general guidance' to Excel to prioritize a certain process or calculation? I know that's a somewhat imprecise question, but I've read other threads that talk about giving Excel some kind of resource-priority as far as processes running on my computer...was wondering perhaps whether there was something similar, but more granular, that essentially identifies a certain Range or calculation-process within an Excel file and labels it "A #1 " / most-important / always give priority to this calculation. I doubt it, but struggling with how to keep the stock-pulling-in functionality of my file as the highest-priority process, because working with stale stock quotes (even just delayed by 5-10 seconds) is not good for me.

 

[jkpieterse]

AFAIK there isn't much you can do there. But if you want to know everything there is to know about Excel's calc engine, start reading on http://decisionmodels.com/calcsecrets.htm