Update Cross-Table References in WPS on iOS FAQ

Common questions about Update Cross-Table References usually involve finding the entry, refresh speed, and checking results; this FAQ includes 3 common questions and a short glossary.

FAQ

Why can't I find the Update Cross-Table References entry?

1. Make sure the file you opened is a smart spreadsheet rather than another document type.
2. Tap the Tools tab at the bottom and check whether the entry appears in the tool list.
3. If it still does not appear, update WPS Office to the latest version and open the spreadsheet again.

What should I do if the spreadsheet becomes slow after I tap update?

1. Wait for the current refresh process to finish and avoid tapping repeatedly.
2. If the spreadsheet contains many cross-table references, a short pause can happen on mobile devices.
3. If the process does not finish for a long time, try the same refresh on a desktop device with higher performance.

How can I tell whether the refresh has taken effect?

1. Return to the cells that contain cross-table references in the current spreadsheet.
2. Compare the values or formula results before and after the refresh.
3. If the results are refreshed and you can continue editing or saving, the update has usually taken effect.

Glossary