Calculation Issues

Fix a WPS Spreadsheet Spin Button That Does Not Update Calendar Dates

Maira MehtabMaira Mehtab Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open Name Manager

Click the Formulas tab on the ribbon and select Name Manager to open the defined names dialog.

2
Locate the calendar year name

Find the defined name used by the calendar, such as ScYear, and select it.

3
Edit the name reference

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.

4
Confirm and test

Click OK, close Name Manager, and click the spin button to verify the calendar dates now recalculate.

Calendar updates with spin button: When the defined name points directly to D2, the spin button should update the calendar dates immediately.

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. 1. Open Name Manager: In WPS Spreadsheets, click the Formulas tab and choose Name Manager.
  2. 2. Select the defined year name: Choose the name used by the calendar, such as ScYear, from the list.
  3. 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. 4. Test the spin button: Click OK and use the spin button to confirm the calendar dates update correctly.
Free, lightweight spreadsheet editing with WPS OfficeUses a familiar Name Manager workflow to fix defined names quicklyMaintains full compatibility with .xls and .xlsx calendar workbooksSpin button and form controls work alongside existing Excel formulas
microsoft office alternative - wps office

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.