Fix WPS Spreadsheets PivotTable Refresh Errors When Other Users Can Refresh
Question details
The user needs to diagnose why a PivotTable fails to refresh for one person while colleagues can refresh the same workbook, using checks such as clearing occupied cells, verifying the source range, and confirming the refresh command.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A shared workbook contains a PivotTable that colleagues refresh successfully, but one user experiences refresh failures and needs step-by-step troubleshooting.
- Observed behavior
- The PivotTable does not update for one user, while other users can refresh the same workbook without errors.
Confirm that all users are opening the same workbook and note the exact refresh error message the affected user sees. Then check whether any cells below or to the right of the PivotTable are occupied, because refresh may need that space to expand.
Clear Occupied Cells and Refresh the PivotTable in WPS Spreadsheets
Use this first when a refresh fails because the PivotTable cannot expand into adjacent cells.
PivotTable refreshes often require empty rows and columns directly below and to the right of the table. If another user has placed values, hidden rows, or formatting in that area, WPS Spreadsheets may block the refresh.
Open the same workbook in WPS Office Spreadsheets that the other users are refreshing.
Select the rows directly below and the columns directly to the right of the PivotTable, then press Delete or move the contents to another sheet.
Click any cell inside the PivotTable to activate the PivotTable tools.
Go to the Data tab and click Refresh All, or right-click the PivotTable and choose Refresh.
Verify the Data Source, Connections, and Credentials
Use this when the affected user sees a data source, connection, or credential error but other users do not.
Save a New Copy, Reopen, and Compare Refresh Settings
Use this when the workbook behaves differently across users due to file version, cached connection, or an inconsistent refresh method.
Refresh a PivotTable Successfully with WPS Office Spreadsheets
Use WPS Office Spreadsheets to clear blocked cells around the PivotTable, verify the data source and connections, and run Refresh All from the Data tab so every user can update the same workbook without switching to another Office suite.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office, open the shared workbook, and click any cell inside the PivotTable.
- 2. Clear cells around the PivotTable: Select and delete or move any data in the rows directly below and the columns directly to the right of the PivotTable.
- 3. Go to the Data tab: Click the Data tab in the ribbon and locate Refresh All.
- 4. Run Refresh All: Click Refresh All and wait for WPS Spreadsheets to update the PivotTable and confirm the rows and columns expand correctly.
- 5. Save the refreshed workbook: Press Ctrl+S or go to File > Save to keep the updated PivotTable for all users.
Frequently Asked Questions
Why can my colleagues refresh a shared PivotTable but I cannot?
This usually happens because you are using a different workbook copy, cells below or to the right of the PivotTable are occupied, your connection credentials are missing, or you are on a different WPS Office version. Check the file, clear the adjacent cells, and use Data > Refresh All.
How do I clear cells that are blocking a PivotTable refresh in WPS?
Open WPS Office Spreadsheets, select the rows directly below and the columns directly to the right of the PivotTable, press Delete or move the data to another sheet, then click inside the PivotTable and choose Data > Refresh All.
Where is Refresh All in WPS Spreadsheets?
Open the workbook and click the Data tab in the ribbon. Then click Refresh All. You can also right-click the PivotTable and choose Refresh to update only that PivotTable.
Does refreshing a PivotTable in WPS Office require the same data source permissions as Excel?
Yes. External connections, workbook links, and query credentials must be accessible to your user account. Check Data > Connections or Data > Edit Links to verify the connection status and update credentials.
What should I do if the workbook still will not refresh after clearing cells?
Save the workbook as a new copy, close and reopen it in the same WPS Office version as your colleagues, click inside the PivotTable, then go to Data > Refresh All. If it still fails, compare the exact error message with a working user.
