Common questions about Merge Workbooks on iOS usually involve file selection, result checking, and large-file handling; this FAQ includes 3 common questions and a glossary.
FAQ
What should I do if a large workbook merge fails?
- Check whether the files included in the merge are too large.
- If there are many files or complex contents, try merging them in batches first.
- If the files come from cloud storage, confirm that your network connection is stable.
- After a successful merge, continue organizing the result file as needed.
How do I merge only selected worksheets?
- Open Merge Workbooks first.
- Select only the worksheets that you want to include.
- Leave unneeded worksheets unselected.
- Add other same-type files and start the merge.
What should I check after the merge is complete?
- Check whether key data has been imported completely.
- Review complex formulas, pivot tables, and chart reference ranges.
- If formatting differs across files, adjust styles and structure after the merge.
Glossary
| Term | Definition |
|---|---|
| Workbook | The spreadsheet file itself, which can contain one or more worksheets. |
| Worksheet | A single sheet inside a workbook that stores and organizes data. |
| Cloud Drive | An online storage location that can be used to select and add files for merging. |