How to Make an Excel Slicer Show All Table Items in WPS Office Spreadsheets
Question details
The user needs an Excel slicer to display every item from the connected table or PivotTable and to remove incorrect connections or leftover manual filters.
- Product
- WPS Office Spreadsheets / Microsoft Excel
- Device & OS
- not provided
- Scenario
- A slicer appears to show only a limited number of rows, so the user wants to verify slicer connections, refresh the source table, and clear any filters that are still applied.
- Observed behavior
- The slicer does not list all table items because it is not linked to the complete table or because manual slicer filters remain active.
Make sure the workbook contains at least one Excel table or PivotTable and that the slicer is selected before you open Report Connections. If you plan to use the VBA method, enable macros or save the workbook in a macro-enabled format.
Check Slicer Connections and Link the Slicer to the Full Table or PivotTable
Use this solution when the slicer only shows a subset of items and you need to confirm that it is connected to the correct table or PivotTable.
A slicer only displays items from the objects selected in Report Connections. If the connection is missing or points to the wrong range, some rows will not appear in the slicer.
Click the slicer in your worksheet so that the Slicer or Options contextual tab appears on the ribbon.
On the Slicer or Options tab, click Report Connections. In some versions this command is named PivotTable Connections.
In the Report Connections dialog box, check the box for the table or PivotTable that contains all the rows you want the slicer to control, then click OK.
Click inside the source table or PivotTable, go to the Data or PivotTable Analyze tab, and choose Refresh or Refresh All to update the slicer item list.
Clear Manual Filters from All Slicer Caches with VBA
Use this solution when the slicer is already connected correctly but still hides items because one or more manual filters remain applied.
Make a Slicer Show All Table Items in WPS Office Spreadsheets
In WPS Office Spreadsheets, select the slicer, open Report Connections from the Slicer tab, link the full table or PivotTable, refresh the data, and clear remaining slicer filters so every item appears.
- 1. Select the slicer: Click the slicer in WPS Office Spreadsheets to activate the Slicer tab on the ribbon.
- 2. Open Report Connections: On the Slicer tab, click Report Connections and select the table or PivotTable that contains all rows.
- 3. Refresh the data source: Click any cell inside the table or PivotTable, go to the Data tab, and choose Refresh All.
- 4. Clear remaining filters: If items are still hidden, run the ClearManualFilter macro from the WPS macro editor to clear all slicer caches.
Frequently Asked Questions
Why does my Excel slicer only show some of the table rows?
It usually means the slicer is not connected to the complete table or PivotTable, or a manual filter is still applied. Select the slicer, open Report Connections, check the correct table, and clear filters or refresh the source data.
Where is Report Connections in WPS Office?
Select the slicer first, and the Slicer or Options contextual tab appears on the ribbon. Report Connections is in the slicer tools group; in some versions it may be named PivotTable Connections.
Will clearing slicer filters delete my slicer?
No. Clearing manual filters only removes the current filter selections. The slicer remains connected to the table or PivotTable and can be used again normally.
Can I clear all slicer filters at once without clicking each slicer?
Yes. Use VBA to loop through ThisWorkbook.SlicerCaches and run cache.ClearManualFilter on each cache. This clears manual filters from all slicers in the workbook at once.
Do I need to refresh after changing Report Connections?
Yes. After changing the connection, click inside the source table or PivotTable and choose Refresh or Refresh All from the Data or PivotTable Analyze tab so the slicer item list updates.
