I am using the MSDN workaround Drillthrough VBA code to enable a drillthough from an Excel pivot table to my OLAP cube. It works fine on 2 PCs in my area. However on a 3rd PC,I get the following error:
"The OLAP provider does not support custom grouping. Custom groups were previously defined for this PivotTable Report.
Do you wish to retain the custom group definitions for the future?....."
All 3 PCs are using Excel 2003. All have data access compone2.8 installed.
We are using Analysis Services on SQL Server 2000 Enterprise Edition.
I have been tearing my hair out trying to find out the differences between the PCs....
Any help would be appreciated.
"The OLAP provider does not support custom grouping. Custom groups were previously defined for this PivotTable Report.
Do you wish to retain the custom group definitions for the future?....."
All 3 PCs are using Excel 2003. All have data access compone2.8 installed.
We are using Analysis Services on SQL Server 2000 Enterprise Edition.
I have been tearing my hair out trying to find out the differences between the PCs....
Any help would be appreciated.