WPS Merge Workbooks on iOS FAQ

Common questions about Merge Workbooks on iOS usually fall into 4 areas: feature access, file selection, merge failure, and result checking; this section includes 4 FAQs.

FAQ

Why can’t I find the Merge Workbooks entry?

1. Confirm that the current file is a spreadsheet.
2. Go to the top menu bar and open More → All Services to check whether the entry is available.
3. Confirm that the current account has WPS Premium because this feature requires membership.
4. If the entry still does not appear, update WPS Office and try again.

What should I do if a large file merge fails?

1. Check the number of files and the amount of content included in the merge.
2. If the files are large, add them in smaller batches and merge them separately.
3. When adding files from cloud storage, keep the network stable and try again.
4. After the merge succeeds, organize the result file step by step.

How do I merge only specific sheets?

1. Open the Merge Workbooks feature page.
2. In the sheet list, select only the sheets that you want to include.
3. Leave unnecessary sheets unselected.
4. Add the other files and start the merge to process only the selected sheet scope.

What should I check after the merge is complete?

1. Check whether all target files were added to the pending merge list.
2. Check whether the result includes the expected sheet content.
3. Review complex formulas, charts, or pivot-related areas to confirm they still match your needs.
4. If you find a problem, select the files or sheets again and rerun the merge.

Glossary