0

I have a problem with slicer in Excel file. In my Excel file I have two worksheets. In the first one, there is a pivot table taking data from OLAP cube and in the second I have a pivot table taking data from another Excel file. I'd like to have one slicer called "Organization" to filter data in both tables. Is it possible?

Kind regards

Konrad Z.
  • 1,592
  • 4
  • 20
  • 34

1 Answers1

3

No - it seems not. Slicers are meant to be used on pivot tables that share the same data source it seems. You should be able to conglomerate your data into one source and create two pivot tables with a shared slicer though.

From Microsoft: http://office.microsoft.com/en-us/excel-help/use-slicers-to-filter-pivottable-data-HA010359466.aspx

Make a slicer available for use in another PivotTable

1.Click the slicer that you want to share in another PivotTable. This displays the Slicer Tools, adding an Options tab.

2.On the Options tab, in the Slicer group, click PivotTable Connections.

3.In the PivotTable Connections dialog box, select the check box of the PivotTables in which you want the slicer to be available.

Or you could just create one pivot table.

Or you could have a look at this: Making all pivot tables on one sheet mimic each other in terms of rows expanding and collapsing

Good Luck.

Community
  • 1
  • 1
Stepan1010
  • 3,136
  • 1
  • 16
  • 21
  • good point. I found it very confusing that sometimes I could control two pivot tables with one slicer and sometimes not - even though I could in both cases specify that the slicer is supposed to influence more than one pivot table. but the difference was that in one case the pivot tables where coming from one and in the other from two sources ... (+1) – Raffael Mar 11 '13 at 16:05