Fix Excel Option Buttons Losing Value After Saving in WPS Office Spreadsheets
Question details
Fix grouped Excel option buttons in WPS Office Spreadsheets that lose their linked value after saving because overlapping group boxes interfere with the control layout.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A user has an Excel-compatible workbook with grouped option buttons and finds that overlapping group boxes affect which value is saved after editing.
- Observed behavior
- Grouped option buttons lose their linked cell value after the workbook is saved and reopened when overlapping group boxes interfere with the control grouping.
Make sure the Developer tab is available in WPS Office Spreadsheets so you can select and edit form controls. If it is not visible, enable it from File > Options > Customize Ribbon before editing the workbook.
Resize overlapping group boxes so each option button group is fully contained
Use this solution when grouped option buttons save the wrong value or lose their linked value after reopening the workbook.
Overlapping group boxes can confuse the grouping logic for Excel option buttons. Separating them ensures each set of radio buttons is evaluated as its own group and the linked cell value remains stable.
Launch WPS Office and open the affected .xlsx workbook in WPS Office Spreadsheets.
If the Developer tab is not visible, go to File > Options > Customize Ribbon, check Developer, and click OK.
On the Developer tab, click the border of each group box around the option buttons to select it.
Drag or resize the group boxes so each set of option buttons is fully inside its intended group box and no group box overlaps another.
Press Ctrl + S to save the workbook, close it, reopen it, and verify that the option buttons keep their linked values.
Recreate option buttons inside cleaned-up group boxes
Use this solution if the current group box layout is too tangled or difficult to repair by resizing alone.
Fix Option Buttons Losing Values After Saving in WPS Spreadsheets
Use WPS Spreadsheets to inspect and adjust the grouped option buttons in your Excel-compatible workbook so they retain their linked cell values after saving.
- 1. Open the workbook: Launch WPS Office and open the affected .xlsx workbook in WPS Spreadsheets.
- 2. Enable the Developer tab: If the Developer tab is missing, go to File > Options > Customize Ribbon, enable Developer, and click OK.
- 3. Select group boxes: On the Developer tab, click each group box border and check for overlapping areas around the option buttons.
- 4. Resize and reposition: Drag or resize the group boxes so every option button group is fully contained and no group box overlaps another.
- 5. Save and test: Press Ctrl + S to save, reopen the workbook, and verify that the option buttons keep their selected values.
Frequently Asked Questions
Why do Excel option buttons lose their value after saving in WPS Office?
This usually happens when overlapping group boxes interfere with the grouping logic for option buttons. Open the Developer tab, select the group boxes, and make sure each set of option buttons is fully contained within its own group box.
How do I enable the Developer tab in WPS Spreadsheets?
Go to File > Options > Customize Ribbon, check the Developer option, and click OK. The Developer tab will then appear in the ribbon.
How can I select a group box that is behind another control?
Click the border of the group box if it is visible. If it is hidden behind another control, open the Selection Pane from the Home tab > Find & Select > Selection Pane and select the group box by name.
How do I link option buttons to a specific cell in WPS Spreadsheets?
Right-click the option button, choose Format Control, open the Control tab, and enter the target cell in the Cell link field. Option buttons in the same group should be linked to the same cell.
Does WPS Spreadsheets support Excel form controls like option buttons?
Yes, WPS Spreadsheets supports Excel-compatible form controls, group boxes, and .xlsx workbooks, so you can open and edit your existing files without changing file format.
