RTD update problem with Excel 2007 when Excel is not the active ap

[Dave]

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?

 

[James Snell]

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!

 

[Rich Wood]

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?

 

[Dave]

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.

 

[Dave]

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.