When using Merge Workbooks, common questions usually involve entry paths, file selection, merge failures, and post-merge review; this section covers 4 frequent questions.
FAQ
Where can I find Merge Workbooks?
- Open a spreadsheet document first.
- Tap the top menu bar “☰”.
- Look for Merge Workbooks under All Services.
- You can also look for Merge Workbooks under More Output & Conversion.
Why can’t I use Merge Workbooks?
- Check whether your account has the required membership benefits.
- Make sure you are working inside a WPS spreadsheet file instead of another file type.
- If the entry is not visible, update WPS Office to the latest version and try again.
What should I do if a large merge fails?
- Check whether the files included in the merge are too large.
- Try reducing the number of files in one merge and complete the task in batches.
- If the files contain complex content, merge first and then organize the result step by step.
What should I check after the merge is complete?
- Check whether complex formula references are still correct.
- Check whether pivot tables and chart reference ranges need adjustment.
- Confirm that important rows and columns are preserved in the result workbook.
Glossary
| Term | Definition |
|---|---|
| Merge Workbooks | The action of combining multiple separate spreadsheet files into one workbook. |
| Cloud file | A spreadsheet stored in cloud documents. Selecting this type of file usually requires a network connection. |
| Local file | A spreadsheet stored on the Android device itself. |
| Reference range | The data area used by formulas, charts, or pivot tables. It is helpful to review these ranges after a merge. |