Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet with RTD formulas in it. When the real time data
changes, excel grabs focus. (ie. excel pops itself to the front) How do I stop excel from grabbing focus? I've seen a couple of posts that seem related, but I haven't found any solutions: http://groups.google.com/groups?hl=e...bl%26rnum%3D14 http://groups.google.com/groups?q=ex...TNGXA11&rnum=1 I've also run many tests and found some odd behavior: If I create an excel workbook with only formulas that use the bloomberg.rtd server, things seem fine (excel does not grab focus). I can have hundreds of these formulas and dependent formulas, etc. If I create an excel workbook that contains references to the rtd server that I have written (in VC++), excel grabs focus when these values change. I have looked through the code for my RTD server very carefully, but I can't seem to find any problems with it. It provides data to excel through the standard RTD interface -- data comes in, I store it in a set, I call UpdateNotify(), when excel has some spare cycles it calls be back with RefreshData() and I give it the data in my set. Any help / insight / workarounds would be appreciated. BTW, I am using WindowsXP / Excel2002. Thanks, steven |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Capturing Real Time Data | Excel Worksheet Functions | |||
creating dataseries from real time data | Excel Worksheet Functions | |||
storing real time data | Excel Discussion (Misc queries) | |||
Excel 2003's autosum does not update data in real time | Excel Worksheet Functions |