Can't Show & Hide Pivot Table Detail Using OLAP

T

Todd C.

Hi, has anyone had any experience with using an OLAP data
source for a pivot table and tried to use the Show and
Hide detail function in Excel? This doesn't seem to work
in Excel 2002. It does if you use a direct link to the
data source(i.e. SQL table) or if you use the Office Web
Component, but not if you use Excel and an OLAP data
source. You get the error message "Cannot show or hide
detail for this selection".
Thanks,
Todd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table accessing data from OLAP cube 0
OLAP Pivot Table returns #N/A for custom calc. 0
DATE Calculations in pivot table 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
OLAP Pivot table - How to show items with no data ? 1
Pivot Table Data Aggregation 0

Top