How to Use WPS Data Range Properties on Windows

Last updated:July 16, 2026

Use Data Range Properties through 3 how-to topics, all available without membership; start from the index and open the matching steps for the setting you need.

How-to Index

No.TopicMembership Requirement
11. Set refresh on file openFree
22. Set scheduled automatic refreshFree
33. Set how row changes are handled after refreshFree

How-to Guide

1. Set refresh on file open

Feature entry: Get Data drop-down menu → Data Range Properties → Refresh data on file open

  1. Right-click the imported linked data range.
  2. Open the Data Range Properties panel.
  3. Select Refresh data on file open in the refresh controls.
  4. Click OK to save the setting.
  5. The next time the spreadsheet is reopened, the latest source data is refreshed automatically.

Success Criteria

  • Interface result: The Data Range Properties panel shows that Refresh data on file open is enabled.
  • Next action: After reopening the file, the imported data updates automatically.

Tips While Using

  • This setting only applies to imported external linked data.
  • If the source cannot be reached, the refresh may not complete when the file opens.

2. Set scheduled automatic refresh

Feature entry: Get Data drop-down menu → Data Range Properties → Refresh frequency

  1. Open the Data Range Properties panel.
  2. Select Refresh frequency in the refresh controls.
  3. Enter the refresh interval in minutes.
  4. Click OK to apply the setting.
  5. While the file remains open, the data refreshes at the interval you set.

Success Criteria

  • Interface result: The refresh frequency option is enabled and shows the configured number of minutes.
  • Next action: While the file stays open, the data updates at the selected interval.

Tips While Using

  • A very short refresh interval may increase access requests to the data source.
  • Choose an interval that matches how often the source data changes.

3. Set how row changes are handled after refresh

Feature entry: Get Data drop-down menu → Data Range Properties

  1. Open the Data Range Properties panel.
  2. Find the setting for how the number of rows in the data range changes upon refresh.
  3. Select one of the following options as needed:
    • Insert cells for new data and delete unused cells.
    • Insert entire rows for new data and clear unused cells.
    • Overwrite existing cells with new data and clear unused cell contents.
  4. Click OK to save the change.

Success Criteria

  • Interface result: The selected row-change handling option is saved.
  • Next action: After the next refresh, the data range expands, overwrites, or clears content according to the selected mode.

Tips While Using

  • Different handling modes can affect nearby worksheet layout, so review the sheet structure before applying changes.
  • When the external data size changes often, choose the option that matches the surrounding layout.