Can you describe the full sequence of events further? When do you "touch the rows"? Before or after the PivotTable cache is cleared?

The way I intended the feature to work is to clear the PivotTable cache, then save the file, then distribute it to other people without fear of cached data revealing something they shouldn't see. I didn't intend for you to clear the cache then continue to interact with the PivotTable, if that's what you're doing.

The error message in the screenshot says essentially that the connection string doesn't specify Cube=YourCube. The OLAP PivotTable Extensions code should add this to the connection string temporarily. If it's having trouble doing that, feel free to edit the connection and add that Cube=YourCubeName property into the connection string yourself to see if that solves the problem.

Cases:
Open excel workbook containing PivotTable, touch the rows then clear PivotTable Cache --> Error
Open excel workbook containing PivotTable, immediately clear PivotTable Cache --> works OK, save.
Open excel workbook containing PivotTable, clear PivotTable Cache, refresh to fill the PivotTable again, touch rows, clear PivotTable Cache --> Error
Save Excel Workbook, reopen it, immediately clear PivotTable Cache --> works OK, save.

Problem: whenever you touch the rows (or columns?) and then clear PivotTable Cache, you get the error and the clear PivotTable Cache does not work.
Workaround: Whenever you touch the rows (or columns?) of a pivotTable, before you clear PivotTable Cache you must first save the Excel workbook. Then after re-opening the Excel workbook immediately clear PivotTable Cache and then save the empty workbook.

Questions:
Where should they enter the Cube=YourCubeName ?
Where does OPTE get the YourCubeName from ?
Perhaps this source looks different in the German version ?

I cannot test it anymore. I have installed the English version of Office and cannot reproduce the problem.

Hi Greg, do you have any comment on my description or answer to m questions?
Regards, Helmut

Sorry for the delay. I don't have any clue on how to fix the problem. But if you can put Cube=YourCubeName in the connection string, that might be a workaround. If you look at the current connection and look at the Command Text, it will show the cube name. The code that grabs the cube name is OLEDBConnection.CommandText.

If you have other suggestions, I'm open to suggestions.

The connection string dialog shows:
Connection Name: DE000-SAS01V OLAP_Fertigartikel Stock_Balance
Connection File: http://bi/Verbindungsbibliothek/DE000-SAS01V OLAP_Fertigartikel Stock_Balance.odc
Connection String: Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=OLAP_Fertigartikel;Data Source=DE000-SAS0V;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error
Command Type: Cube
Command Text: Stock_Balance

Looks correct to me - even the cube name is shown in the Command Text.
What do you think?
Regards, Helmut

The customer did include the Cube=MyCube; in the connection string and the error did not occur. Any idea why it is not inserted by the code?