I have created a very simple modal form with two buttons: one just closes the form, and the other calls Application.RTD.RefreshData. In Excel 2003 this all works just fine, but in Excel 2010 the Application.RTD.RefreshData crashes with
If I create the form as modeless everything works fine in both Excel 2003 and Excel 2010.Run-time error '1004': Application-defined or object-defined error
For what it's worth, this is all the code behind the form:
And I invoke the form using this code in my sheet:![]()
Please Login or Register to view this content.
Is this a known issue with Excel 2010, or am I really not allowed to call Application.RTD.RefreshData from a modal form?![]()
Please Login or Register to view this content.
EDIT:
I should add that as far as I can tell I have no RTD servers in the Excel session.
EDIT2:
This workbook demonstrates the problem. Would be very grateful if anyone could confirm whether they see the same issue, and in which version of Excel...
RTD simplest.xls
Bookmarks