Excel 2010 Slicer Connection / Pivot Table Problem

  • Thread starter Thread starter Dave Bybee
  • Start date Start date
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.
 
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.
.
 
Both pivot tables must use the same data connection. I experienced a similar
problem and this fixed it.
 
Back
Top