WPS Data Range Properties on Windows FAQ

Common questions about Data Range Properties usually involve refresh issues, imported result behavior, and source changes; this FAQ covers 3 frequent questions plus a glossary.

FAQ

Why does the data not refresh automatically when I open the file?

1. Confirm that the selected range is imported external linked data.
2. Open Data Range Properties and check whether Refresh data on file open is enabled.
3. Make sure the data source is currently available and the network or file path is accessible.
4. Reopen the file and check whether the data updates automatically.

Why does the data not update on time after I set a refresh frequency?

1. Confirm that Refresh frequency is enabled and a valid number of minutes is entered.
2. Keep the file open until the configured interval is reached.
3. Check whether the external data source can still be accessed normally.
4. If needed, refresh once manually and then review the setting again.

What should I do if an error appears after the source file is moved?

1. Open the worksheet that contains the affected data range.
2. Go to the related data property or connection setting area.
3. Specify the new source path or another accessible location.
4. Save the change and refresh again to confirm that the data works normally.

Glossary