I have an excel listobject that refreshes data from an external data source,
allows users to edit, and then publish back to the data source. Users
interact with the list through an add-in that provides ribbon options for
publish, refresh, etc.
The only access to the data source is through a custom .NET API - ADO.NET
and OLAP interfaces are not available. I do not have control over the APIs
exposed from the data source.

I need to hook the refresh into the "Refresh" and "Refresh All" options for
Excel, but I cannot seem to do this because my list is not based on a
QueryTable. The reason I need to hook into Refresh/RefreshAll, is to enable
users who are building pivot tables from this listobject to hook into the UI
refresh options.

Is this possible/supported? Any suggestions appreciated.

Thanks.
Mareen