WPS Data Range Properties on macOS: Introduction

WPS Data Range Properties on macOS helps you manage refresh behavior and row-change handling for imported external data ranges; this guide covers 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	Matches the number of membership-related rows in the index

About This Feature

Overview

Data Range Properties is a WPS Office for Mac spreadsheet feature for managing how imported external data refreshes and how the worksheet handles row changes after a refresh.

Core capabilities include:

Refresh data when the file opens so linked data can sync with the latest source content.
Refresh data on a schedule by setting a time interval in minutes.
Choose how row changes are handled after refresh when the source returns more or fewer records.

This feature is useful for recurring reports, linked data tracking sheets, and worksheets connected to changing external sources.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office for Mac
App version	The latest version of WPS Office is recommended so spreadsheet import and refresh options are available
Network	A stable internet connection is recommended when refreshing external linked data; no mandatory network requirement for viewing saved results
Other	An imported external data range must already exist in the worksheet, and you need permission to edit the file

Download & Installation

Install WPS Office for Mac before using Data Range Properties.

Item	Details
Official download	WPS Office Free Download
Verification after installation	Open WPS Spreadsheets, load a worksheet that contains imported external data, and confirm that the Data Range Properties entry is available from the related Get Data workflow

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Supports refresh on file open, scheduled refresh by minute interval, and row-change handling for imported external data ranges in a spreadsheet.	Excel supports external data range properties, connection settings, and options for handling larger or smaller returned data sets after refresh.	Google Sheets mainly uses import functions such as IMPORTDATA, IMPORTHTML, IMPORTXML, and IMPORTRANGE to bring in external data and check for updates under platform rules.	Notion supports importing CSV and spreadsheet content and also offers synced databases for some connected tools, but its workflow is centered more on database organization than spreadsheet range properties.	Adobe Acrobat Sign supports refreshing an existing data export record and generating a new CSV for updated report output.
WPS Advantages	Advantage: WPS keeps refresh triggers and row-change handling in one spreadsheet settings panel. Distinct: It fits worksheet-based external data maintenance without switching to a separate query workflow.	Compared with WPS: Excel offers broader connection and query management, but the workflow can involve more connection-oriented settings.	Compared with WPS: Google Sheets relies more on formulas and browser-based document behavior, with less focus on a dedicated property panel for one imported range.	Compared with WPS: Notion is stronger for collaborative databases and imported content organization, not for spreadsheet-style external data range property control.	Compared with WPS: Adobe focuses on refreshing exported report records rather than managing spreadsheet data range properties.
Official Source	—	Manage external data ranges and their properties	Learn more about Import functions	Import data into Notion	Refresh the content in an existing data export

Overall Conclusion
If your work centers on maintaining imported external data inside a spreadsheet, WPS Data Range Properties provides a direct worksheet-based setup for refresh behavior and row handling. Other products cover related needs through connection management, import functions, database imports, or report export refresh workflows.

Use Cases

No.	Scenario	Suitable for	Main issue	How this feature helps
1	Auto-sync data when a file opens	Operations, sales, and finance users	Manual refresh is repeated every time the workbook opens	Turn on refresh when opening the file
2	Update monitoring data on a schedule	Analysts who watch changing data	Repeated manual refresh takes time	Enable refresh frequency and set a minute interval
3	Keep worksheet layout under control after refresh	Users maintaining complex sheets	Source row changes can affect content below the range	Choose the row-change handling option that fits the sheet
4	Manage linked data ranges in one place	Spreadsheet users who import external data often	Refresh-related settings are easy to miss	Use Data Range Properties as the central settings panel
5	Work with dynamic external sources	Teams tracking changing source data over time	Added or removed records can change worksheet behavior	Select insert cells, insert entire rows, or overwrite existing cells

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Basic use of Data Range Properties	✅ Available	✅ Available
Core Office features	✅ Available	✅ Available
Expanded PDF tools, cloud storage, and other suite benefits	Limited scope as shown on the pricing page	More expanded benefits are available

Source: WPS Office pricing page

Recommendations

Use case	Recommended plan	Why
You mainly need to configure Data Range Properties and manage routine refresh tasks	Free	The feature description does not show a membership requirement for these tasks
You also need broader PDF, cloud, or other suite benefits	WPS Premium	A membership plan is more suitable when you need additional product benefits beyond this spreadsheet feature

Get membership: Subscribe to WPS Premium