WPS Cross-Workbook Reference lets you reference cells or ranges from other spreadsheet files in the current workbook; 4 core tasks are covered, with 4 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 4 | Matches the number of rows in the How-to Index |
| Available without membership | 4 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
| Version limit | None | The feature information shows no version restriction |
| Membership limit | None | The feature information shows no membership restriction |
About This Feature
Overview
Cross-Workbook Reference is a built-in WPS Spreadsheet feature on Windows for linking cell or range data from other spreadsheet files into formulas in the current workbook. It is useful for cross-file summaries, synchronized viewing, and centralized calculations.
Core tasks include:
- Start a cross-workbook reference by typing
=in a cell for a quick entry point. - Insert a cross-workbook reference from the Formulas tab when you want a guided workflow.
- Change an existing cross-workbook reference to point to a different file or range.
- Update reference results to sync the latest data from the source file.
This feature is useful for monthly summary workbooks, team-maintained trackers, recurring reports, and spreadsheet workflows that depend on data from multiple files.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device that can run WPS Office |
| App version | It is recommended to use the latest version of WPS Office |
| Network | A network connection is recommended when the referenced file is stored online or in a collaborative workspace |
| Other | You need access to the referenced spreadsheet file and permission to view it |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation | Download the Windows installer and complete setup with the installation wizard |
| Check after installation | Open WPS Spreadsheet, then confirm that the Formulas tab includes the Cross-Workbook Reference entry |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | References cells or ranges from other spreadsheet files in the current workbook and provides insert, change, and update actions for the reference. | Excel supports workbook links, also called external references, to combine data from other workbooks or other sheets in the same workbook. | Google Sheets uses IMPORTRANGE to import a range from another spreadsheet and refreshes receiving sheets when the source changes. | Notion uses Relations and Rollups to connect databases and aggregate related properties across records. | Adobe Acrobat can combine multiple files into one PDF for sharing and review, but it does not provide spreadsheet cell-level cross-file references. |
| WPS Advantages | Advantage: It provides both a direct = trigger and a ribbon-based entry path. Distinct: It groups insert, change, and update actions around the same spreadsheet reference workflow. | Compared with WPS: Excel provides workbook links through formula-based external references and link management, with documentation centered more on formula behavior and workbook links. | Compared with WPS: Google relies on IMPORTRANGE, permissions, and online refresh behavior, which fits cloud spreadsheets well. | Compared with WPS: Notion is designed for database relations and rollups rather than workbook-style cell formulas across spreadsheet files. | Compared with WPS: Adobe focuses on combining and organizing files in PDF format rather than spreadsheet reference workflows. |
| Official Source | — | Create workbook links | IMPORTRANGE | Relations and rollups | Merge multiple PDF documents, images and files |
Overall Conclusion: WPS Cross-Workbook Reference is well suited to spreadsheet users who want both a direct formula entry path and a guided ribbon workflow. For cross-file spreadsheet summaries and ongoing reference maintenance, it keeps the main actions in one place and aligns with common workbook-based tasks.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How this feature helps |
|---|---|---|---|---|
| 1 | Monthly summary workbook | Finance teams, operations teams | Data is spread across multiple workbooks and manual consolidation takes time | Reference key ranges from other files directly in the summary workbook |
| 2 | Team-maintained tracker | Project teams, administrative staff | Different people maintain different files and the main tracker is hard to keep aligned | Pull data from collaborative files into one main workbook and update it when needed |
| 3 | Local and cloud file linkage | Individual users, department coordinators | Data stored in different locations needs to be reviewed together | Reference spreadsheet data from local files or online files in the current workbook |
| 4 | Periodic data refresh | Analysts | Source data changes but result sheets stay outdated | Use Update References to refresh the latest values |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Basic cross-workbook reference usage | ✅ Available | ✅ Available |
| Basic PDF tools | ✅ Available | ✅ Available with broader tool coverage |
| Templates | Basic templates | More advanced templates |
| Cloud storage | 1 GB | 20 GB |
| AI tools | Limited access for some tools | More AI tools and higher usage allowances |
Source: WPS Office pricing page
Recommendations
| Usage scenario | Recommended plan | Why |
|---|---|---|
| Everyday cross-workbook references and basic summaries | Free | The feature information shows no membership restriction for this feature |
| More cloud storage, templates, and additional document tools | WPS Premium | Suitable when you also need broader document services and added benefits |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page