Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Excel drillthrough to OLAP error

Author  Topic  cgkitab Starting Member 6 Posts Posted - 2006-09-29 : 13:28:36 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.