Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel thesis topics | Excel Discussion (Misc queries) | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. | Excel Programming | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) |