WPS Data Range Properties on macOS FAQ

Find answers to 3 common questions about refresh behavior, update timing, and worksheet layout changes when using WPS Data Range Properties on macOS.

FAQ

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

1. Confirm that the selected area is an imported external linked data range.
2. Right-click the range, open Data Range Properties, and check whether Refresh data when opening the file is enabled.
3. Make sure your network connection is available and the source location can still be reached.
4. Reopen the file and check whether the refresh starts.

Why does scheduled refresh not update the data as expected?

1. Check whether Refresh frequency is enabled and whether the minute value is correct.
2. Make sure the worksheet remains open while you expect updates to occur.
3. Confirm that the external source is reachable and that the source data has changed.
4. If needed, run a manual refresh first to confirm the connection is working.

Why does content below the range move after refresh?

1. Open Data Range Properties.
2. Review the current option for how row changes are handled after refresh.
3. If you do not want entire rows to move, switch to the overwrite option when it fits your worksheet.
4. Save the setting and refresh again to check the updated layout behavior.

Glossary