LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel thesis topics Calvin[_2_] Excel Discussion (Misc queries) 0 December 21st 09 12:23 AM
Opening Excel, Book1 opens, remains open with other workbook open DanieB Excel Discussion (Misc queries) 0 September 3rd 09 08:23 AM
Open a specific workbook...find value from other open workbook and then insert cells values in cell next to it. [email protected] Excel Programming 1 May 13th 07 01:46 PM
excel 2003 saved file will not open without a blank workbook open Bob Excel Discussion (Misc queries) 4 November 11th 06 04:24 PM
Excel workbook does not open in open window on desktop DeanH Excel Discussion (Misc queries) 2 March 8th 05 09:51 AM


All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"