WPS Cross-Workbook References on macOS FAQ

When using Cross-Workbook References, the most common questions involve file access, supported file types, and data refresh behavior; this FAQ covers 3 common questions and practical fixes.

FAQ

Why does WPS say the file cannot be found when I reference another spreadsheet?

1. Check whether the target file is still in the original location or whether a cloud file has been moved.
2. Confirm that your current account has permission to access the file.
3. Re-select the target file, then insert or change the cross-workbook reference again.

Can Cross-Workbook References use non-spreadsheet files?

1. Cross-Workbook References is mainly used with spreadsheet file formats that support data reading.
2. Text documents, presentations, and other non-spreadsheet formats are not suitable as reference sources for this feature.
3. If needed, move the data into a spreadsheet file before creating the reference.

How to update cross-workbook references in WPS on Mac when the data does not refresh?

1. First confirm that the source file has been saved.
2. Open Cross-Workbook References from the Formulas tab and select Update References.
3. If the source is a local file, make sure the file is accessible before refreshing the results.

Glossary