slicer connections

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Slicer connections

Slicer connections

resolvedResolved · Medium Priority · Version 2016

Michael has attended:
Excel Advanced course

Slicer connections

I have 9 different pivots/charts based off the same data source and all contained within the one spreadsheet. I inserted a slicer to allow for selection of data on one particular source.

However the slicer will only connect to 6 of the pivots/charts. The other 3 do not connect, nor do they show up in the report connections list.

What can I do to connect all my pivtos/charts to a single slicer? If I update any cells within the source data, could this impact on slicer connectivity?

Thanks

RE: Slicer connections

Hi Michael

Thank you for your question.

Slicers only work on PivotTables that have the exact same data range. If one PivotTable has a data range that is out by a single row or column, the slicer won't see that PivotTable.

Also while the slicer can stop the PivotTable from Changing the Data Source if connected to more than one PivotTable, it won't stop you from refreshing any changes to the existing data. You just wouldn't be able to add new records to the PivotTable.

You would need to disconnect the slicer from the PivotTables, update all the PivotTables and then reconnect the slicers. Converting your data to tables before creating the PivotTable can avoid this problem though.

Hope this helps

Kind regards
Wendy Canelas
Microsoft Office Trainer


 

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips


Server loaded in 0.07 secs.