I've been trying to change the Command Text of a List Object in Excel 2007 during runtime from within a method of the worksheet, written in C#. The whole point is that the user should be able to select the table from a combo box and the list object should change accordingly.
Changing of the command text is mostly possible, but none of the refresh methods (neither of the whole workbook nor the List Object, Query Table, Connection or OLEDB-Connection) works.
The funny thing is that if I manually refresh in Excel, everything works fine.
Has somebody any clue how to refresh the data in the object from within the code?