Pivot Table Issues

Excel for Mac: Connect One Slicer to Multiple PivotTables

Natalie TaylorNatalie Taylor Nov 12, 2026 870 views

Question details

The user needs to use one slicer to filter multiple PivotTables and related charts in Excel for Mac.

Excel for Mac: Connect One Slicer to Multiple PivotTables
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.
Before you start

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.

Solution 1Recommended

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.

1
Use one common source

On the worksheet, confirm that both reports can use the same Excel table or source range, including all required columns and headers.

2
Create the first PivotTable

Select the common source, open the Insert tab, choose PivotTable, and create the first report.

3
Create the second PivotTable

Select the same source table or range again, choose Insert > PivotTable, and create the second report rather than selecting a different range.

4
Insert the slicer

Click either PivotTable, open PivotTable Analyze, choose Insert Slicer, select the field, and click OK.

5
Connect the other PivotTable

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.

Check the connection list: Both PivotTables should appear in Report Connections after they are created from the same source cache. If one is missing, it was likely created from a different range or cache.
Free Microsoft Office alternative

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. 1. Download WPS Office: Select Download WPS Office Free and install the spreadsheet application on your Mac.
  2. 2. Open the Excel workbook: Launch WPS Office, choose Spreadsheet, and use File > Open to select the XLS or XLSX workbook.
  3. 3. Review the report structure: Check the imported source tables, PivotTables, slicers, and charts, then adjust the report layout as needed.
Free and lightweight spreadsheet software for everyday report workFamiliar worksheet, table, chart, and PivotTable workflowsSupports Microsoft Excel XLS and XLSX file formats for easier migrationHelps organize and present data without requiring a Microsoft 365 subscription
microsoft office alternative - wps office

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.