When using WPS Split Table, common questions usually involve split conditions, result syncing, and collaboration impact; this FAQ includes 3 frequent questions and a glossary.
FAQ
Why is the Split by list empty?
- Check whether the Split Range is selected correctly.
- Make sure the selected range includes the column you want to use as the split basis.
- If the first row contains field names, turn on Data contains header.
- Open the Split by list again and choose the target column.
Do split results sync automatically with the source table?
- Split results are created as separate copies.
- Later updates in the source table do not sync automatically to existing split results.
- If you need the latest data, run the split operation again.
Will Split Table affect other collaborators in a shared file?
- Yes. The operation can add worksheets or create new documents.
- It is a good idea to communicate with current collaborators before running it.
- If you save results as different new documents, the impact on the original collaborative file is smaller.
Glossary
| Term | Definition |
|---|---|
| Split by Content | A method that groups one data range by the values in a selected column and creates separate results. |
| Split by Worksheet | A method that outputs multiple worksheets from the current workbook as separate documents. |
| Data contains header | An option that tells WPS the first row of the selected range is a header row and should be kept in each result. |