How to Make More PivotTables Available to an Excel Slicer in WPS Office
Question details
The user wants to make additional PivotTables appear in an Excel slicer's Report Connections list in WPS Office Spreadsheets.

- 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.
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.
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.
Click inside each PivotTable, open the PivotTable Tools/Options tab, and check its data source range or table.
If a PivotTable uses a different range, create it again from the same Excel Table or range used by the slicer-connected PivotTables.
Click the slicer, go to the Slicer Tools/Options tab, and click Report Connections.
In the Report Connections dialog, check the boxes for the PivotTables you want this slicer to control, then click OK.

Fix Data Model Relationship Issues That Hide Compatible PivotTables
Use this when the PivotTables are based on related Data Model tables but still do not appear in Report Connections.
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. Open the workbook in WPS Office Spreadsheets: Launch WPS Office Spreadsheets and open the Excel workbook containing the slicer and PivotTables.
- 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. Select the slicer and open Report Connections: Click the slicer, go to Slicer Tools/Options, and choose Report Connections.
- 4. Enable the additional PivotTables: Check the boxes for every PivotTable you want the slicer to control, then click OK to apply.

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.




