View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] craig@ttmab.co.uk is offline
external usenet poster
 
Posts: 1
Default Excel RTD - no topics on workbook open

In common with
http://groups.google.co.uk/group/mic...1e0616f686017a,
having created an Excel RTD server I find that after saving a workbook
(Excel 2003) with RTD functions referencing that server and opening
again, Excel shows only the last (now stale) data and does not update.

Running in the VS 2005 debugger reveals that no topics are subscribed
to by the reopened workbook, though the RTD server is receiving it's
info from a remote server (RTD server is local, it just connects to a
remote server to retrieve values) and running the Excel
Application.RTD.RestartServers does not seem to have any effect.
Wrapping the RTD function which was suggested elsewhen on this list
similarly does not work.

The RTD server is written in VB.NET though I don't see how that would
make a difference. I also can't see that it's the RTD server's job to
save the topics Excel is subscribing to, across openings of the
workbook - Excel wouldn't know about the topics after reopening again
anyhow, presumably?

Any clues v gratefully received.

Thanks, Craig