To configure automatic refresh for data connections in WPS Spreadsheet, start by opening the workbook that contains the external data link you wish to update automatically.
Confirm the connection is operational and points to an accessible data source, including network drives, cloud storage, or local files.
Find and select the “Data” tab in the main interface to access your connection management tools.
Find the Refresh option and click the dropdown caret to reveal additional configuration settings.
Choose the “Connection Properties” entry to launch the settings interface tailored to your data source.
Look for the “Refresh every” setting under the Refresh Control tab, which features a checkbox and a field to define the interval in minutes.
Set the refresh interval according to your data’s update frequency: use 5 minutes for real-time feeds, 15 for daily updates, or 60 for hourly data.
If you wish to continue editing or navigating while refreshes occur, tick the “Enable background refresh” option.
Click “OK” to finalize the settings and close the connection properties dialog.
It is essential that the data source remains available and unchanged while WPS Spreadsheet is running, otherwise auto-refresh will fail.
For authenticated connections, store your username and password in the credential manager or select “Save password” to prevent repeated logins.
Perform a test by refreshing manually, then let the timer elapse to verify the system updates data without user intervention.
With these settings properly applied, your WPS Spreadsheet will now update external data automatically at your preferred intervals, eliminating the need for repetitive manual refreshes.