When using Cross-Workbook Reference, the most common questions focus on file access, supported source file types, and data refresh behavior, with 3 high-frequency topics covered here.
FAQ
What should I do if WPS cannot find the referenced file?
- Confirm that the target file has not been deleted, moved, or renamed.
- Confirm that your current account still has permission to access the file.
- If it is a team file, ask the file owner or manager to confirm the sharing scope.
- Insert or change the Cross-Workbook Reference again and select a valid file.
Can Cross-Workbook Reference use non-spreadsheet files?
- Cross-Workbook Reference is intended for spreadsheet file formats that support data reading.
- Use common spreadsheet files such as
.xlsxor.csvwhen possible. - Text documents, presentation files, and other non-spreadsheet formats cannot be used as the source for this feature.
Why are my referenced results not updating automatically?
- Confirm that the source file changes have already been saved.
- Open the Cross-Workbook Reference menu from the Formulas tab.
- Select Update References to refresh the results manually.
- For local files, confirm that the file path is still valid and the source file is accessible.
Glossary
| Term | Definition |
|---|---|
| Cross-Workbook Reference | A feature that references cell or range data from another spreadsheet file in the current workbook. |
| Reference range | The target cell or cell range read by the current formula. |
| Source file | The spreadsheet file that contains the referenced data. |
| Update References | The action that syncs the latest source data back into the current workbook. |