Excel for Mac: Connect One Slicer to Multiple PivotTables
Question details
The user needs to use one slicer to filter multiple PivotTables and related charts in Excel for Mac.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Multiple PivotTables need to respond to the same slicer selection.
- Observed behavior
- Only one PivotTable appears in the slicer's Report Connections list, so the slicer cannot filter the other PivotTables or charts.
Check whether the PivotTables use the same source range, table, or Data Model. Confirm that the source fields and column headers needed by both reports are available before recreating either PivotTable.
Create both PivotTables from the same source cache
Use this method when the PivotTables can be built from the same worksheet range or Excel table.
A slicer can control multiple PivotTables only when those PivotTables share the same PivotTable cache. Creating each PivotTable from the same source range or table normally gives them a shared cache.
If the existing PivotTables were created from different ranges, recreate them from one common source before connecting the slicer.
On the worksheet, confirm that both reports can use the same Excel table or source range, including all required columns and headers.
Select the common source, open the Insert tab, choose PivotTable, and create the first report.
Select the same source table or range again, choose Insert > PivotTable, and create the second report rather than selecting a different range.
Click either PivotTable, open PivotTable Analyze, choose Insert Slicer, select the field, and click OK.
Select the slicer, open the Slicer tab, choose Report Connections, select both PivotTables, and click OK. The connected PivotTables and their linked charts will respond to the slicer.
Build both PivotTables from a shared Data Model
Use this option when the reports combine related tables or need a common model instead of one worksheet range.
Use WPS Office as a Lightweight Alternative for PivotTable Reports
WPS Office provides a familiar spreadsheet interface for opening, editing, and sharing Excel workbooks. It is free, lightweight, and supports common Microsoft Excel formats, making migration straightforward when you need an accessible alternative for PivotTable-based reports.
- 1. Download WPS Office: Select Download WPS Office Free and install the spreadsheet application on your Mac.
- 2. Open the Excel workbook: Launch WPS Office, choose Spreadsheet, and use File > Open to select the XLS or XLSX workbook.
- 3. Review the report structure: Check the imported source tables, PivotTables, slicers, and charts, then adjust the report layout as needed.

Frequently Asked Questions
Why does only one PivotTable appear under Report Connections?
The PivotTables were likely created from different source ranges, tables, or PivotTable caches. A slicer lists only PivotTables that share a compatible cache or Data Model.
Can one slicer filter PivotCharts as well as PivotTables?
Yes. A PivotChart linked to a PivotTable responds when that PivotTable is selected in the slicer's Report Connections list. Connect every relevant PivotTable first.
Do the PivotTables need identical layouts to share a slicer?
No. They can have different row, column, and value arrangements, but they must use the same PivotTable cache or shared Data Model and include the slicer's field.
How can I fix PivotTables that were created from separate ranges?
Recreate both PivotTables by selecting the same Excel table or source range from Insert > PivotTable. Then select the slicer, choose Slicer > Report Connections, and enable both reports.
Can Excel for Mac connect PivotTables from related tables?
Yes, when the Excel version supports a shared Data Model and the tables have appropriate relationships. If Data Model or Power Pivot commands are unavailable, build both PivotTables from one common source instead.




