Update Cross-Table References in WPS on iOS: Introduction

Update Cross-Table References in WPS on iOS helps you refresh cross-table reference results in smart spreadsheets 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 iOS smart spreadsheets. It updates all cross-table reference values or formula results in the current sheet at once, helping keep referenced data current and consistent.

Key capabilities include:

Refresh all cross-table references in the current sheet with one action.
Check updated reference results quickly on mobile devices.
Support spreadsheet workflows that depend on data referenced from other tables.

System Requirements

Item	Requirement
Operating system	An iPhone or iPad that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	If referenced files depend on online sync, keep a stable network connection
Other	You need to open a smart spreadsheet that already contains cross-table references

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, open a smart spreadsheet, and check whether the Update Cross-Table References entry appears under Tools

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides an Update Cross-Table References entry in smart spreadsheets on iOS, so you can refresh all cross-table references in the current sheet at once.	Microsoft Word supports linked objects that can update when the source file changes, but the official guidance focuses on document objects rather than a one-tap mobile spreadsheet command for cross-table references.	Google Docs and Google Slides support linked charts, tables, and slides, and users can run Update all for multiple linked objects. This workflow is centered on linked objects between Docs or Slides and Sheets.	Notion uses relations and rollups to connect databases, and related content reflects changes across databases. The official workflow is database-oriented rather than a spreadsheet command for manually refreshing cross-table references.	Adobe Acrobat supports adding and managing links in PDFs. Its official guidance focuses on document navigation and link targets rather than spreadsheet reference refresh workflows.
WPS Advantages	Advantage: WPS provides a direct entry inside a mobile smart spreadsheet, which fits quick refresh tasks for the current sheet.	Compared with WPS: the official feature set emphasizes linked objects in document workflows, with less focus on a dedicated iOS smart spreadsheet refresh entry.	Compared with WPS: Google supports batch updating linked objects, but the workflow is mainly for Docs or Slides linked with Sheets instead of an equivalent spreadsheet command on iOS.	Compared with WPS: Notion is better aligned with database relationships and rollups than with spreadsheet-style reference refresh actions.	Compared with WPS: Adobe focuses on PDF links and destinations, so the use case is different from updating spreadsheet references.
Official Source	—	Linked objects and embedded objects	Link a chart, table, or slides to Google Docs or Slides	Relations & rollups	Add links to PDFs

Overall Conclusion
If your main goal is to refresh cross-table references quickly in a smart spreadsheet on iOS, WPS is more closely aligned with that task. The other products provide official linking or relationship features as well, but their primary focus is document objects, database relationships, or PDF links rather than this spreadsheet workflow.

Use Cases

No.	Scenario	Suitable users	Main issue	How this feature helps
1	Checking the latest referenced results on mobile	People working away from a desk	Referenced values may not be current when the file is opened	Refresh the current sheet with Update Cross-Table References
2	Verifying whether cross-table formulas are in sync	Data organizers	Manual checking across multiple tables takes time	Refresh first, then review the updated values or formula results
3	Reviewing spreadsheet data before sharing	Team collaborators	Referenced content should be current before sending or presenting a file	Run one refresh before sharing the spreadsheet
4	Handling complex spreadsheets lightly on iOS	iOS spreadsheet users	Updating references one by one is inconvenient on mobile	Use the tool entry to refresh references in the current sheet together
5	Troubleshooting outdated reference results	General users	Results may lag after a long period without refresh	Refresh first, then decide whether desktop follow-up is needed

Membership & Benefits

Free vs WPS Premium

Item	Free users	WPS Premium
Update Cross-Table References	Available	Available
Basic PDF features	Available	Available
Cloud storage	1 GB	20 GB or more depending on plan
Template resources	Limited downloads	More template benefits
Some advanced tools	Limited or unavailable	More advanced capabilities available

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
You only need to refresh cross-table references on iOS	Free	This feature can be used without membership
You also need more cloud storage and additional advanced tools	WPS Premium	A better fit if you also need storage, templates, or more advanced features

Membership page: Subscribe to WPS Premium