When using Create New Pivot Table, the most common questions are about save location, data import, and creation limits; this FAQ covers 3 common questions.
FAQ
Where is the new pivot table saved?
- The new multidimensional table is saved as an online document by default.
- Open WPS cloud documents or the document list to find the file you just created.
- If needed, move it to a specific folder for easier management.
Can I import data from Excel or another spreadsheet file to create a pivot table?
- On iOS, this workflow is mainly for creating a blank multidimensional table directly.
- If you need to move content from another spreadsheet, first open and organize the original data on the appropriate device.
- Then transfer the content into the multidimensional table as needed for continued use.
Is there a limit on how many pivot tables I can create?
- The current feature description does not list a creation limit.
- You can create multiple multidimensional tables as needed.
- It is helpful to organize them by project or purpose for easier lookup later.
Glossary
| Term | Definition |
|---|---|
| Multidimensional table | A table format for online organization, record keeping, and collaboration that starts from a blank structure. |
| Online document | A document type stored in the cloud and saved in real time, usually with a network connection. |
| Cloud documents | The storage area used to keep and manage online documents across devices. |