Pivot Table Issues

How to Make More PivotTables Available to an Excel Slicer in WPS Office

Adam DavisAdam Davis Nov 13, 2026 870 views

Question details

The user wants to make additional PivotTables appear in an Excel slicer's Report Connections list in WPS Office Spreadsheets.

How to Make More PivotTables Available to an Excel Slicer in WPS Office
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
The user has multiple PivotTables in a workbook and an existing slicer, but wants the slicer to control more PivotTables.
Observed behavior
Only PivotTables that share the same data source or use compatible Data Model relationships are listed in Report Connections; unrelated PivotTables do not appear.
Before you start

Open the workbook in WPS Office Spreadsheets and confirm which PivotTables currently appear in the slicer's Report Connections. Check that each missing PivotTable is based on the same Excel Table/range or on tables that are linked in the Data Model.

Solution 1Recommended

Connect PivotTables That Share the Same Data Source

Use this when all desired PivotTables should be based on the same Excel Table or range so the slicer can control them together.

A slicer can only list PivotTables that are built from the same source data. If a PivotTable is created from a different range, connection, or unrelated table, it will not appear in Report Connections.

1
Check the source of each PivotTable

Click inside each PivotTable, open the PivotTable Tools/Options tab, and check its data source range or table.

2
Re-create mismatched PivotTables from the shared source

If a PivotTable uses a different range, create it again from the same Excel Table or range used by the slicer-connected PivotTables.

3
Open Report Connections for the slicer

Click the slicer, go to the Slicer Tools/Options tab, and click Report Connections.

4
Enable the compatible PivotTables

In the Report Connections dialog, check the boxes for the PivotTables you want this slicer to control, then click OK.

Connect PivotTables That Share the Same Data Source
Slicer connection updated: The compatible PivotTables are now controlled by the same slicer.

Set Up Excel Slicer Connections in WPS Office Spreadsheets

WPS Office Spreadsheets gives you a free way to open, edit, and manage Excel slicers and PivotTables. You can align data sources, use Report Connections, and control multiple compatible PivotTables while keeping the familiar .xlsx format.

  1. 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office Spreadsheets and open the Excel workbook containing the slicer and PivotTables.
  2. 2. Review the PivotTable data sources: Click each PivotTable and use the PivotTable Tools tab to check that they share the same Table/range or Data Model tables.
  3. 3. Select the slicer and open Report Connections: Click the slicer, go to Slicer Tools/Options, and choose Report Connections.
  4. 4. Enable the additional PivotTables: Check the boxes for every PivotTable you want the slicer to control, then click OK to apply.
Connect multiple compatible PivotTables to one slicer through Report ConnectionsFull compatibility with Excel .xlsx workbooks, slicers, and PivotTablesFree and lightweight Office suite with a familiar ribbon interfaceNo need to install Microsoft Office to manage Excel slicer connections
microsoft office alternative - wps office

Frequently Asked Questions

Why don't all my PivotTables appear in Report Connections?

Report Connections only lists PivotTables that share the same data source or use compatible Data Model relationships. Check each PivotTable's source and rebuild any that come from an unrelated range or connection.

Can I connect PivotTables from different worksheets to one slicer?

Yes, as long as the PivotTables on those worksheets are created from the same Excel Table, range, or related Data Model tables. Open the slicer's Report Connections and enable them.

How do I open Report Connections for a slicer in WPS Office?

Click the slicer, then go to the Slicer Tools or Options tab and select Report Connections from the ribbon.

What should I check when a Data Model relationship is involved?

Use the slicer field from the one-side table rather than the corresponding many-side field. Then reopen Report Connections and see if the related PivotTables become available.