We have implemented OLE DB for OLAP provider which supports only the
functions needed to support Excel. It works almost fine with Excel 2007 Pivot
tables.

From our perpective the Show Properties in Report and Show Properties in
Tooltip quick menu options are problematic.

1) Excel seems to create new DataSource for this task. Since our provider
does not persist password, it will prompt for password and when the user
enters the password and clicks ok in our password dialog, the menu closes.
When user reopens the menu, Excel tries again create new DataSource which
causes password promting and menu closes. So the user cannot open the menu at
all.

We temporalily allowed the provider to persist password as a work around for
the first issue and run into more interesting problem.

2) Excel starts to create DataSource objects/sessions in infinite loop when
you take your mouse over the menu item. I guess our provider does not support
some property and/or interface Excel expects the provider to supply. And
because the provider does not function as Excel expects it tries to fix the
problem by trying again.

Could someone provide some information what properties / interfaces Excel
tries to use when user opens the 'Show Properties in Report' menu.