WPS Cross-Table Reference on Windows FAQ

Common questions about Cross-Table Reference on Windows usually involve file access, reference ranges, and refresh behavior; this FAQ includes 4 common questions and a 4-term glossary.

FAQ

Why does WPS say it cannot find the file when I reference another spreadsheet?

1. Confirm that the source file is still saved in its original location.
2. Check whether your current account has permission to access the file, especially for shared or team files.
3. If the file was moved or renamed, use Change Cross-Table Reference to point to the correct file again.

Can Cross-Table Reference use non-spreadsheet files?

1. Cross-Table Reference is intended for spreadsheet files that support data retrieval.
2. Do not use text documents or presentation files as the reference target.
3. If you need to reference data, move the content into a supported spreadsheet file first.

What should I do if the linked data does not update?

1. Open the Formulas tab.
2. Select Cross-Table Reference → Update Reference.
3. If the result still does not refresh, check whether the source file has been saved with the latest content and whether the current file can still access it.

Why can’t I reference a new file that has not been saved yet?

1. Save the source spreadsheet file first.
2. Make sure the file is stored in an accessible location, such as a valid local path or an online document location.
3. Return to the destination file and insert the cross-table reference again.

Glossary