Excel 2010 Slicer Connection / Pivot Table Problem

D

Dave Bybee

Working in Excel 2010 beta. I have two pivot tables created from
different SSAS cubes. I have PowerPivot add in installed, but not
using it for this project. The two pivot tables both share several
similar dimensions. When I try to connect a given slicer to both pivot
tables, the 2nd pivot table is not available in the "Pivot Table
Connections" window. The only pivot table listed in the "Pivot Table
Connections" is the one for which the slicer was originally created.

All of the posts I've seen so far say that all the pivot tables in the
workbook should appear in the "Pivot Table Connections" window.

Thanks.
 
S

sgrothaus

Dave Bybee said:
Working in Excel 2010 beta. I have two pivot tables created from
different SSAS cubes. I have PowerPivot add in installed, but not
using it for this project. The two pivot tables both share several
similar dimensions. When I try to connect a given slicer to both pivot
tables, the 2nd pivot table is not available in the "Pivot Table
Connections" window. The only pivot table listed in the "Pivot Table
Connections" is the one for which the slicer was originally created.

All of the posts I've seen so far say that all the pivot tables in the
workbook should appear in the "Pivot Table Connections" window.

Thanks.
.
 
S

sgrothaus

Both pivot tables must use the same data connection. I experienced a similar
problem and this fixed it.
 

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

Top