How to Keep Excel Slicer Connections When Replacing PivotTable Data in WPS Office Spreadsheets
Question details
The user needs to replace raw data in the source sheet without losing slicer-to-PivotTable report connections across worksheets.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Several PivotTables and slicers are connected across worksheets, and new raw data has a different number of rows than the previous source range.
- Observed behavior
- Slicer report connections appear lost after pasting new raw data into the source sheet.
Before replacing data, confirm that every PivotTable is based on the same source table or Data Model, and that the source header names exactly match the fields used by the slicers.
Use an Excel Table as the Dynamic Source for All PivotTables
Best when you need to update raw data regularly and keep slicer connections intact as the data range grows or shrinks.
An Excel Table gives PivotTables a dynamic named range instead of a fixed cell range, so replacing data rows does not break the underlying connection. Keep the header row unchanged because slicers rely on field names.
In WPS Spreadsheets, select the source data including the header row, click Home > Format as Table, and choose a table style.
Click inside a PivotTable, go to PivotTable Tools > Options > Change Data Source, and set the source to the table name instead of a fixed range.
Select the rows below the header row in the source table, paste the new raw data, and leave the header row untouched.
Click Data > Refresh All, or right-click a PivotTable and choose Refresh.
Click a slicer, go to Slicer Tools > Options > Report Connections, and confirm all intended PivotTables are checked.
Reconnect Slicers Through Report Connections If Links Are Lost
Use this solution when the source data was already replaced and one or more slicers no longer filter the expected PivotTables.
Keep Slicer Connections Intact When Updating PivotTable Data in WPS Office Spreadsheets
WPS Office Spreadsheets lets you use an Excel Table as a dynamic PivotTable source, refresh all reports, and preserve slicer connections when raw data changes.
- 1. Create the source table: In WPS Spreadsheets, select the source range including headers and click Home > Format as Table.
- 2. Base PivotTables on the table: For each PivotTable, go to PivotTable Tools > Options > Change Data Source and point it to the table name.
- 3. Replace only the data rows: Paste new raw data below the existing header row instead of overwriting the header row.
- 4. Refresh and verify slicers: Click Data > Refresh All, select a slicer, and open Slicer Tools > Options > Report Connections to confirm the PivotTables are checked.
Frequently Asked Questions
Why do slicer connections disappear after I paste new data into Excel?
This usually happens because PivotTables are based on a fixed range or the header row was replaced. Use an Excel Table as the data source and avoid pasting over the headers.
How do I replace PivotTable source data without losing slicer connections?
Store the source data as an Excel Table, point every PivotTable to that table, replace only the data rows below the headers, then refresh and check the slicer Report Connections.
Can WPS Office Spreadsheets use the Excel Table method to keep slicers connected?
Yes. WPS Spreadsheets supports Excel Tables, PivotTables, slicers, and report connections, so the same table-based workflow applies.
What if a PivotTable does not appear in the slicer Report Connections list?
Verify that all PivotTables use the same source table or Data Model. If a PivotTable uses a different source, change its data source and try Report Connections again.
Do I need to recreate slicers after adding new rows to the source table?
No. If the source is an Excel Table and the headers remain unchanged, refreshing the PivotTables should preserve the existing slicers and their report connections.
