Update Cross-Table References in WPS on Android lets you refresh cross-table reference results in AirSheet with one tap; this guide covers 1 core task, with 1 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 1 | Matches the number of rows in the How-to Index |
| Available without membership | 1 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
Update Cross-Table References is a refresh feature in WPS Office for Android AirSheet. It lets you update all cross-table reference values or formula results in the current sheet with one tap, helping keep referenced data accurate and current.
Core capabilities include:
- Refresh all cross-table references in the current sheet at once, reducing repeated manual checks.
- Review updated reference results quickly on mobile when you need current data.
- Support daily tracking, summary, and collaboration scenarios that rely on linked data across sheets.
If a sheet contains many cross-table references, running an update helps confirm that the displayed results are synced to the latest available state.
System Requirements
| Item | Requirement |
|---|---|
| OS | Android device |
| App version | Use the latest version of WPS Office when possible |
| Network | Keep a stable internet connection if the referenced data needs online sync |
| Other | You need to open an AirSheet that already contains cross-table references |
Download & Installation
| Item | Details |
|---|---|
| Official Download | WPS Office Free Download |
| Post-install Check | Install and open WPS Office, then open an AirSheet and check the bottom Tools tab for Update Cross-Table References |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Provides an Update Cross-Table References entry in AirSheet on Android and can refresh all cross-table references in the current sheet at once. | Word supports manually updating fields such as cross-references, bookmarks, formulas in tables, and tables of contents, mainly in document field workflows. | Google Docs can link charts, tables, or slides to source files and lets users click Update to refresh linked objects in the document. | Notion uses Relations and Rollups to connect databases so related content can appear and aggregate across databases. | Adobe InCopy supports cross-references and provides commands to update cross-references in document publishing workflows. |
| WPS Advantages | Advantage: direct mobile entry for AirSheet on Android; Distinct: refreshes all cross-table references in the current sheet in one action. | Compared with WPS: focuses on document fields and cross-references rather than a mobile AirSheet command for cross-table sheet references. | Compared with WPS: updates linked charts, tables, and slides inside the Google Docs ecosystem rather than sheet-level cross-table references in AirSheet. | Compared with WPS: centers on database relations and rollups instead of a dedicated one-tap command to refresh cross-table reference results inside a sheet. | Compared with WPS: centers on cross-references in publishing documents rather than mobile spreadsheet-style cross-table reference refresh. |
| Official Source | — | Update fields | Link a chart, table, or slides to Google Docs or Slides | Relations & rollups | Cross-references |
Overall Conclusion
If you need a mobile way to update cross-table references in an AirSheet, WPS offers a more direct path on Android. Other products also support updating references, linked objects, or related data, but their workflows focus more on document fields, linked content, database relations, or publishing references.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | Reviewing a summary sheet on mobile | Everyday spreadsheet users | It is unclear whether referenced results are current after opening the sheet | Open Tools and run Update Cross-Table References |
| 2 | Handling linked data while away from a computer | Mobile workers | Cross-table results cannot be refreshed from a desktop in time | Refresh them directly on Android |
| 3 | Checking formula-based references | Sheet maintainers | Too many cross-table references make manual checking slow | Refresh all cross-table references in the current sheet together |
| 4 | Verifying data after collaboration | Team collaborators | Results may need confirmation after multiple edits | Update cross-table references before continuing review or editing |
| 5 | Pre-checking a large sheet before review | Heavy spreadsheet users | Large updates make it harder to tell whether results are current | Run an update first, then inspect key referenced areas |
Membership & Benefits
This section explains whether Update Cross-Table References on Android needs a paid plan, compares free and paid coverage at a high level, and shows where to subscribe.
Free vs WPS Premium
Based on the current feature scope, Update Cross-Table References is available without membership. The WPS pricing page also describes free and paid plans, with paid plans generally including more advanced tools and more cloud storage.
| Feature | Free User | WPS Member |
|---|---|---|
| Update Cross-Table References | ✅ Available | ✅ Available |
| Cloud storage | 1 GB | 20 GB or more depending on the plan shown on the pricing page |
| Templates and advanced tools | Partial access | More advanced tools and resources |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| You only need to update cross-table references | Free | This feature is available without membership for basic use |
| You also need more advanced tools and resources | WPS Member | Better fit if you need more cloud storage, templates, or other extended capabilities |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page