I'm trying to implement excelRTDserver.py (<a href="http://www.math.uiuc.edu/~gfrancis/illimath/windows/aszgard_mini/movpy-2.0.0-py2.4.4/movpy/lib/win32com/demos/excelRTDServer.py">http://www.math.uiuc.edu/~gfrancis/illimath/windows/aszgard_mini/movpy-2.0.0-py2.4.4/movpy/lib/win32com/demos/excelRTDServer.py</a>). I'm running Excel 2010 (32bit) so I change the EXCEL_TLB_MINOR value to 7. The add-in is visible in the Excel add-ins list and if I enter =RTD("Python.RTD.TimeServer","","seconds","5") into a cell, I get the current time. But it never updates. If I change the "5" to another number, I get an update but after the initial change it never updates.<br>
<br>I've isolated the problem to an exception raised when the callback object returned by Excel is attempted to be cast into a IRTDUpdateEvent object. This was discussed on this list previously (<a href="http://mail.python.org/pipermail/python-win32/2011-March/011324.html">http://mail.python.org/pipermail/python-win32/2011-March/011324.html</a>) but no solution. I tried the suggested solution of using CastTo, but when EnsureDispatch is called within gencache.py it raises the exception at the first line within the try statement (ti = disp._oleobj_.GetTypeInfo()).<br>
<br>So my question is how do I get the callback object to work? Any help would be greatly appreciated.<br>