Stop Excel Slicers from Filtering Unrelated Tables in WPS Office Spreadsheets
Question details
The user wants to understand why Excel slicers appear to filter unrelated Power Query tables and how to prevent a slicer connected to one table from visually filtering other tables in the same worksheet.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has multiple Power Query tables or regular Excel tables side by side on the same worksheet and uses slicers connected to one table or PivotTable.
- Observed behavior
- Selecting a slicer hides entire worksheet rows, so unrelated tables in the same rows look filtered even though they are not connected to that slicer.
Open the workbook in WPS Office Spreadsheets and select the worksheet that contains the slicers and tables. Check whether the tables are side by side in the same rows before changing slicer connections.
Move Overlapping Tables to Separate Worksheets or Non-Overlapping Rows
Use this solution when slicers visually hide rows that contain unrelated tables because the tables share the same worksheet rows.
In Excel and WPS Office Spreadsheets, filtering an Excel table can hide entire worksheet rows. If another table occupies those same rows, it also disappears even though the slicer is not connected to it.
Double-click the Excel workbook with the slicers and open it in WPS Office Spreadsheets, then select the worksheet that contains the overlapping tables.
Right-click the sheet tab, choose Insert Worksheet, and name it so you can move one table to its own sheet.
Select the full data range of the table you want to separate, right-click the selection, choose Cut, click the new sheet, and paste it into the desired location.
Return to the original slicer, click a filter item, and confirm that only the intended table changes while the other table remains visible.
Check Slicer Connections to Stop Unintended Multi-Table Filtering
Use this solution when the slicer is genuinely connected to more tables or PivotTables than intended.
Control Slicers Correctly in WPS Office Spreadsheets
Open the Excel workbook in WPS Office Spreadsheets, separate overlapping table rows, and use slicer connection settings to make each slicer filter only the intended table or PivotTable.
- 1. Open your workbook: Launch WPS Office Spreadsheets and open the Excel file that contains slicers and related tables.
- 2. Separate overlapping tables: Move one table to a new worksheet so its data rows no longer share the same worksheet rows as the other table.
- 3. Check slicer connections: Click the slicer, open Slicer Tools > Report Connections, and clear any unintended table or PivotTable checkboxes.
- 4. Test the filter behavior: Select different slicer items and confirm only the intended table or PivotTable is filtered.
Frequently Asked Questions
Why does my Excel slicer hide a table I did not connect it to?
If the table shares rows with the filtered table on the same worksheet, hiding entire worksheet rows makes it look filtered. Move the table to another worksheet or arrange it so its data rows do not overlap.
Can one slicer control multiple PivotTables?
Yes, but only when the PivotTables share a compatible source connection. Open the slicer's Report Connections dialog in WPS Office Spreadsheets to select or clear connected PivotTables.
How do I remove a slicer connection from a Power Query output table?
Select the slicer, open Slicer Tools > Report Connections, uncheck the table or PivotTable that should not respond, and click OK.
Does WPS Office support slicers in existing Excel workbooks?
Yes, WPS Office Spreadsheets can open Excel workbooks with slicers and provides slicer tools to edit connections and check filter behavior.
