This project has moved and is read-only. For the latest updates, please go here.

Extensions not working when data is grouped

Topics: Resolved
Sep 3, 2009 at 8:30 PM


I've been working on creating a pivot table connected to an external SQL 2005 warehouse.  I was able to add the row labels and column labels and then create a new private calculated member.  However, when I select some rows of data to group them my private calculated member disappears from the field list and from my pivot table.

When I attempt to re-add the private calculated member to the pivot table I get the following error message

"There was a problem create the calculation: Exception from HRESULT:0x800A03EC"

Am I doing something wrong or are private calculated members created by this add-in not available for groups?

Any assistance is greatly appreciated.

Sep 3, 2009 at 9:12 PM

Unfortunately that's a bug in Excel, not in OLAP PivotTable Extensions. See this thread:

I would report to Microsoft. I've heard people haven't had great success convincing them it's a bug in Excel, but keep trying, because it definitely is.

Marked as answer by furmangg on 6/10/2014 at 3:48 PM