When using Shared Workbook, the most common 3 question types are choosing a collaboration method, handling conflicts, and understanding feature limits; this section covers the top 3 answers.
FAQ
What is the difference between Shared Workbook and cloud document collaboration?
- Shared Workbook usually relies on a shared folder and local network access.
- Cloud document collaboration stores and opens files in the cloud, which is better for remote teamwork.
- If team members are not on the same network, choose a cloud collaboration method first.
How do I handle data conflicts when multiple users edit at the same time?
- Open the Shared Workbook settings window.
- Go to the advanced options and review the conflict handling settings.
- Choose the save conflict method that matches your team workflow before starting multi-user editing.
What are the feature limits of Shared Workbook in WPS on Windows?
- In shared mode, some advanced spreadsheet operations may be limited.
- If you need to merge cells, use conditional formatting, apply data validation, or insert illustrations, exit shared mode first.
- After finishing those edits, enable Shared Workbook again if needed.
Glossary
| Term | Definition |
|---|---|
| Shared Workbook | A collaboration method that allows multiple users to edit the same spreadsheet file at the same time. |
| Workbook merging | A method for combining changes made by multiple collaborators in the same workbook. |
| Conflict handling | The rule used to decide how changes are kept when multiple users edit and save at the same time. |