When using WPS Pivot Table, common questions usually involve refresh behavior, collaborative editing, and sorting; this FAQ includes 3 common questions and a short glossary.
FAQ
Why did the Pivot Table not update after the source data changed?
- Click any cell inside the Pivot Table.
- Right-click and select Refresh.
- If the source range has changed significantly, check the source data range again before continuing the analysis.
Can other people edit the same Pivot Table at the same time in collaboration mode?
- Other collaborators can view the results in the shared file.
- If multiple people change the same Pivot Table layout at the same time, the analysis process may become inconsistent.
- It is recommended that one person manages the Pivot Table layout while others review the results and refresh when needed.
How do I sort values in a Pivot Table?
- Find the field value you want to sort in the Pivot Table.
- Right-click that value and select Sort.
- Choose ascending or descending order, then review the result together with filters if needed.
Glossary
| Term | Definition |
|---|---|
| Pivot Table | A spreadsheet structure used to summarize, group, and analyze source data. |
| Field panel | The panel used to drag fields into Filters, Columns, Rows, and Values when creating or editing a Pivot Table. |
| Refresh | The action that updates the current Pivot Table results after the source data changes. |