Slicer Report Connections

%3CLINGO-SUB%20id%3D%22lingo-sub-1503867%22%20slang%3D%22en-US%22%3ESlicer%20Report%20Connections%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503867%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20am%20having%20a%20problem%20with%20slicer%20report%20connections.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EWithin%20my%20Excel%20Workbook%20I%20have%202%20(eventually%203)%20tabs%20with%20dashboards%20that%20I%20have%20created.%20I%20applied%205%20different%20slicers%20to%20the%20first%20dashboard%20and%20connected%20them%20to%20the%20appropriate%20pivot%20tables%20%E2%80%93%20no%20problem.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EOn%20my%20second%20dashboard%20I%20created%20another%205%20slicers%20and%20connected%20them%20to%20different%20pivot%20tables%20but%20connected%20to%20the%20same%20data%20source%20as%20the%20pivot%20tables%20used%20on%20the%20first%20dashboard.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EWhat%20has%20happened%20is%20when%20I%20select%20the%20appropriate%20report%20connections%20on%20the%20second%20dashboard%20it%20changes%20the%20report%20connections%20on%20the%20first%20dashboard!!%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EIs%20there%20a%20box%20somewhere%20that%20needs%20to%20be%20ticked%20or%20un-ticked%20that%20allows%20you%20to%20use%20slicers%20on%20separate%20worksheets%20within%20a%20workbook%20that%20allows%20you%20to%20link%20to%20different%20pivot%20tables%20using%20the%20same%20data%20source%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20hope%20this%20makes%20sense%20%E2%80%93%20HELP!!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1503867%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi,

I am having a problem with slicer report connections.

Within my Excel Workbook I have 2 (eventually 3) tabs with dashboards that I have created. I applied 5 different slicers to the first dashboard and connected them to the appropriate pivot tables – no problem.

On my second dashboard I created another 5 slicers and connected them to different pivot tables but connected to the same data source as the pivot tables used on the first dashboard.

What has happened is when I select the appropriate report connections on the second dashboard it changes the report connections on the first dashboard!!

Is there a box somewhere that needs to be ticked or un-ticked that allows you to use slicers on separate worksheets within a workbook that allows you to link to different pivot tables using the same data source?

I hope this makes sense – HELP!!

0 Replies