WPS Data Range Properties on Windows: Introduction

WPS Data Range Properties is a spreadsheet feature for managing refresh behavior for imported external data; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	All listed tasks are available directly

About This Feature

Overview

Data Range Properties in WPS Spreadsheets is used to manage how imported external data refreshes inside a worksheet. It lets you refresh data when the file opens, refresh data automatically at a set interval, and choose how row changes are handled after a refresh.

Core capabilities include:

Refresh on file open: update linked external data automatically each time the spreadsheet is reopened.
Scheduled refresh: set a refresh interval in minutes to reduce manual updates.
Row change handling after refresh: choose whether new data inserts cells, inserts entire rows, or overwrites existing cells.

This feature is useful when a worksheet depends on web data, text imports, or other external sources that need to stay current over time.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	A network connection is recommended when refreshing external data or accessing the source
Other	External linked data must already be imported into the worksheet before Data Range Properties can be used

Download & Installation

Item	Details
Official download	WPS Office Free Download
Verify after installation	Open WPS Spreadsheet and a worksheet that contains imported external data, then check the related Get Data entry for Data Range Properties

Source: WPS download center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Lets you set refresh on file open, scheduled refresh, and row-change handling for imported external linked data in a worksheet.	Excel lets users manage external data range properties, including refresh behavior plus formatting and layout handling for imported data.	Google Sheets uses IMPORT functions to bring in external data and automatically checks for updates while the document is open.	Notion supports file import and selected synced database workflows, focusing on bringing outside content into pages or databases.	Adobe Acrobat Analyzer can link a SharePoint folder as a collection that stays synchronized with source changes.
WPS Advantages	Advantage: WPS keeps refresh triggers and row-change handling in one spreadsheet setting panel, which fits routine worksheet maintenance.	Compared with WPS: Excel covers broader external connection management and layout controls, but the setup is more connection-oriented.	Compared with WPS: Google Sheets mainly relies on formulas and refresh rules instead of a dedicated data range properties panel.	Compared with WPS: Notion is oriented toward content import and synced databases rather than spreadsheet data range refresh settings.	Compared with WPS: Adobe focuses on linked document collections and source synchronization, not spreadsheet refresh behavior.
Official Source	—	Manage external data ranges and their properties	Learn more about Import functions	Import data into Notion	Create a linked collection

Overall Conclusion
If your main goal is to maintain imported external data inside a spreadsheet and control both refresh timing and post-refresh layout behavior, WPS Data Range Properties is a practical fit. Other products also provide import or sync workflows, but they focus more on connection management, formula-based imports, content aggregation, or linked document collections.

Use Cases

No.	Scenario	Suitable Users	Main Pain Point	How This Feature Helps
1	Refreshing reports automatically when opened	Finance and operations staff	External data still needs manual refresh after opening a file	Turn on refresh on file open
2	Monitoring changing data on a schedule	Data coordinators	Repeated manual refresh is inefficient	Set a refresh interval in minutes
3	Handling changing row counts after refresh	Analysts	Layouts can shift when imported data grows or shrinks	Choose the row-change handling mode that fits the sheet
4	Maintaining long-term linked worksheets	Project collaborators	Worksheet content falls out of sync with the source	Use automatic refresh to keep data current
5	Managing imported web or text results	General office users	Imported ranges need more stable update behavior	Combine refresh settings with row-change handling

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic use of Data Range Properties	✅ Available	✅ Available
Core WPS Office apps	✅ Available	✅ Available
More advanced PDF, template, and extended features	Some features are limited	More advanced features and higher allowances are available
Cloud storage	1 GB	20 GB or more depending on the plan shown on the pricing page

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You only need to configure external data refresh in spreadsheets	Free	This feature can be used directly for routine worksheet maintenance
You also need more PDF, template, or cloud storage capabilities	WPS Premium	Better suited for broader office and document workflows

WPS membership center: Subscribe now