Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RTD update problem with Excel 2007 when Excel is not the active ap
Have a RTD server DLL (C++, DevStudio 2003). Works fine with Excel 2002 and
2003. On Excel 2007, however, if the excel does no have focus, update interval is like a minute. If Excel has focus, it updates fine. Any idea? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
RTD update problem with Excel 2007 when Excel is not the active ap
That sounds like it's by design so probably out of your hands. Although if
anyone wants to prove me wrong then they're very welcome! "Dave" wrote: Have a RTD server DLL (C++, DevStudio 2003). Works fine with Excel 2002 and 2003. On Excel 2007, however, if the excel does no have focus, update interval is like a minute. If Excel has focus, it updates fine. Any idea? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
RTD update problem with Excel 2007 when Excel is not the activ
We are using RTD with Excel 2007 and haven't experienced that problem. As I'm
writing this I have a spreadsheet with links to real-time stock data running behind this window and it's getting updated continuously. I can't think of what would cause that behavior. Could you put in some debugging code to see if Excel is calling the RefreshData method of your RTD server? We are having a different problem. If we open a second workbook in an existing instance of Excel with links to the same data referenced in the first workbook, the cells in the second workbook retain the values from the last time the workbook was saved. Excel is supposed to update the cells containing those links when the workbook is opened. It works fine in Excel 2002/2003. We've set all the options we can find to allow macros/update links automatically/etc. Have you noticed this? "James Snell" wrote: That sounds like it's by design so probably out of your hands. Although if anyone wants to prove me wrong then they're very welcome! "Dave" wrote: Have a RTD server DLL (C++, DevStudio 2003). Works fine with Excel 2002 and 2003. On Excel 2007, however, if the excel does no have focus, update interval is like a minute. If Excel has focus, it updates fine. Any idea? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
RTD update problem with Excel 2007 when Excel is not the activ
Thanks for the info. What is your throttleInterval setting? In my case, if
I have it set to < 1000 (say 100), I will notice the problem right away. If it is 1000 or above, it happens much less but still happen if the computer is busy doing things. I made a copy of the same file and opened it. Looks like I do have the same issue you discribed. The second book displays the saved value. However, it does update if there is an update. "Rich Wood" wrote: We are using RTD with Excel 2007 and haven't experienced that problem. As I'm writing this I have a spreadsheet with links to real-time stock data running behind this window and it's getting updated continuously. I can't think of what would cause that behavior. Could you put in some debugging code to see if Excel is calling the RefreshData method of your RTD server? We are having a different problem. If we open a second workbook in an existing instance of Excel with links to the same data referenced in the first workbook, the cells in the second workbook retain the values from the last time the workbook was saved. Excel is supposed to update the cells containing those links when the workbook is opened. It works fine in Excel 2002/2003. We've set all the options we can find to allow macros/update links automatically/etc. Have you noticed this? "James Snell" wrote: That sounds like it's by design so probably out of your hands. Although if anyone wants to prove me wrong then they're very welcome! "Dave" wrote: Have a RTD server DLL (C++, DevStudio 2003). Works fine with Excel 2002 and 2003. On Excel 2007, however, if the excel does no have focus, update interval is like a minute. If Excel has focus, it updates fine. Any idea? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
RTD update problem with Excel 2007 when Excel is not the activ
I resolved my problem. Originally, I only call UpdateNotify() once to
inform Excel there is new updates until a RefreshData call from Excel. Now I call UpdateNotify() whenever I have an update and that resolved the probelm. When Excel does not have focus, somehow Excel 2007 ignores some UpdateNotify() call? Microsoft folks, if you monitor newsgroup, would appreciate your input. "Dave" wrote: Thanks for the info. What is your throttleInterval setting? In my case, if I have it set to < 1000 (say 100), I will notice the problem right away. If it is 1000 or above, it happens much less but still happen if the computer is busy doing things. I made a copy of the same file and opened it. Looks like I do have the same issue you discribed. The second book displays the saved value. However, it does update if there is an update. "Rich Wood" wrote: We are using RTD with Excel 2007 and haven't experienced that problem. As I'm writing this I have a spreadsheet with links to real-time stock data running behind this window and it's getting updated continuously. I can't think of what would cause that behavior. Could you put in some debugging code to see if Excel is calling the RefreshData method of your RTD server? We are having a different problem. If we open a second workbook in an existing instance of Excel with links to the same data referenced in the first workbook, the cells in the second workbook retain the values from the last time the workbook was saved. Excel is supposed to update the cells containing those links when the workbook is opened. It works fine in Excel 2002/2003. We've set all the options we can find to allow macros/update links automatically/etc. Have you noticed this? "James Snell" wrote: That sounds like it's by design so probably out of your hands. Although if anyone wants to prove me wrong then they're very welcome! "Dave" wrote: Have a RTD server DLL (C++, DevStudio 2003). Works fine with Excel 2002 and 2003. On Excel 2007, however, if the excel does no have focus, update interval is like a minute. If Excel has focus, it updates fine. Any idea? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My Subtotal is not Active excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 - Text Box (Active X) title | Excel Discussion (Misc queries) | |||
Display of Active Cell in MS Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 (Trial) Active X Problems | Excel Discussion (Misc queries) | |||
Excel 2003 - Update or Don't Update Links Problem | Excel Programming |