Fix a WPS Spreadsheet Spin Button That Does Not Update Calendar Dates
Question details
The user needs to fix a spin button that changes the year cell D2 but does not update the calendar dates because the calendar formulas depend on a defined name rather than directly on D2.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- You have an interactive calendar in WPS Spreadsheets where a spin button changes the year in cell D2.
- Observed behavior
- The spin button updates D2, but the calendar dates do not recalculate. Manually changing the year may work because the calendar formulas depend on a defined name rather than directly on D2.
Open the workbook in WPS Spreadsheets and confirm that the Developer tab is visible so you can check the spin button link if needed. Also note the cell that the spin button changes, such as D2, and the defined name used by the calendar formulas.
Update the Calendar Defined Name in Name Manager
Use this when the spin button changes the year cell but the calendar formulas still use a defined name that does not point to that cell.
Calendar formulas often reference a defined name such as ScYear instead of the year cell itself. If that name points elsewhere, changing the spin button value updates only the cell, not the calendar.
Click the Formulas tab on the ribbon and select Name Manager to open the defined names dialog.
Find the defined name used by the calendar, such as ScYear, and select it.
In the Refers To field, enter a direct reference to the year cell, for example =Sheet1!$D$2, using the actual worksheet name in your workbook.
Click OK, close Name Manager, and click the spin button to verify the calendar dates now recalculate.
Verify Calendar Formulas and Spin Button Link
Use this if the calendar still does not update after editing the defined name, to confirm the formulas and button are configured correctly.
Fix the Calendar Spin Button with WPS Spreadsheets Name Manager
Open Name Manager in WPS Spreadsheets, point the calendar's defined year name to the spin button cell, and the calendar will recalculate whenever the button value changes.
- 1. Open Name Manager: In WPS Spreadsheets, click the Formulas tab and choose Name Manager.
- 2. Select the defined year name: Choose the name used by the calendar, such as ScYear, from the list.
- 3. Point the name to the linked cell: In Refers To, enter =Sheet1!$D$2 or click the year cell D2 to insert the reference.
- 4. Test the spin button: Click OK and use the spin button to confirm the calendar dates update correctly.

Frequently Asked Questions
Why does the spin button change the year but not the calendar dates?
This usually happens because the calendar formulas use a defined name such as ScYear instead of reading the spin button cell directly. Open Formulas > Name Manager and set the name's reference to the year cell, for example =Sheet1!$D$2.
Where is Name Manager in WPS Spreadsheets?
Click the Formulas tab on the ribbon, then select Name Manager. You can view, edit, and create defined names there.
How do I know which defined name the calendar uses?
Select a date cell in the calendar and check the formula bar. If the formula contains a name such as ScYear, that is the name you need to update in Name Manager.
What should the defined name refer to?
It should refer directly to the cell linked to the spin button, normally the year cell. For example, use =Sheet1!$D$2 and replace 'Sheet1' with your actual worksheet name.




