RTD Links retain previous values in certain conditions -- bug?

R

Rich Wood

When I open a new instance of Excel 2007 and create an RTD reference I get
the correct value. Now (in the same instance of Excel) I open a previously
saved workbook with a duplicate RTD reference, i.e. same parameters as the
reference I just created, and it retains the value from the last time the
workbook was saved. If I edit the formula (F2) and hit enter, it updates the
cell with the new value. I put a break point in the ConnectData method and it
was hit when I created the first formula but not when I subsequently opened
the saved workbook. The formula calculation method is set to automatic and F9
does not update the stale RTD reference. If I save the workbook in 2002/2003
format and repeat the scenario in Excel 2003, the problem does not occur.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel RTD - no topics on workbook open 2
Excel RTD function calculates functions twice 0
RTD methods in excel called before workbook_open event 0
RTD problems in Excel 2003 2
How to use RTD + Bloomberg/Reuters 0
Cannot debug RTD Excel 0
RTD C# implementation on vs2005 0
How to get a reference to the Excel application inside a classimplementing IRTDServer 0

Top