When using WPS Pivot Table, common questions usually focus on refresh behavior, collaborative editing, and sorting settings; this page includes 3 frequent questions and a glossary.
FAQ
Why didn’t the Pivot Table update after the source data changed?
- Click any cell in the Pivot Table.
- Right-click and select Refresh.
- If the source range itself has changed, check and reset the source data range.
Can other people edit the same Pivot Table at the same time in collaboration mode?
- Multiple people can view the same collaborative document.
- If several people change the same Pivot Table configuration at the same time, result conflicts may occur.
- It is recommended that one person adjusts the Pivot Table structure while others review results or update the source data.
How to sort values in a Pivot Table in WPS on Windows?
- Right-click the field value that you want to sort in the Pivot Table.
- Select Sort.
- Choose ascending or descending order as needed, and adjust the displayed results with filter rules in the field panel if necessary.
Glossary
| Term | Definition |
|---|---|
| Pivot Table | An analysis table structure used to categorize, summarize, and analyze source data from multiple dimensions. |
| Field panel | The area used after creating a Pivot Table to place fields into Filters, Columns, Rows, and Values. |
| Refresh | The action that recalculates and updates Pivot Table results after the source data changes. |