Fix Excel Option Buttons Not Linking After Adding a Worksheet
Question details
Groups of linked Excel option buttons that previously worked across multiple worksheets fail or mirror selections with an offset after a new sheet is added.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- A user adds a new worksheet to a workbook containing multiple Form Control option buttons and attempts to utilize or link new buttons.
- Observed behavior
- Existing option button groups stop working or exhibit an offset in their mirrored selections. The newly created option buttons on the new sheet fail to function despite correct cell references.
Ensure the Developer tab is enabled in your Excel ribbon, as you will need access to Form Controls to verify grouping properties and cell links.
Verify Group Box Placement and Cell Links
Incorrect grouping can cause option buttons to share the same linked cell inadvertently, resulting in mirrored or offset selections across your workbook.
Form Control option buttons placed on a worksheet share a single linked cell by default unless they are physically enclosed within a Group Box control. When adding new sheets or copying controls, these boundaries can become confused or retain hidden properties.
Navigate to the Developer tab on the Excel ribbon to ensure your form controls are selectable.
Verify that each distinct set of option buttons is completely enclosed within a 'Group Box' form control.
Right-click an option button inside a group, select 'Format Control', and click the 'Control' tab.
Ensure the 'Cell link' field points to the correct, dedicated cell for that specific group. Check if the sheet reference is improperly absolute (e.g., 'Sheet1!$A$1' instead of just '$A$1').

Recreate Option Buttons on the New Worksheet
If copied form controls are corrupted or retaining hidden properties from the previous sheets, recreating them from scratch provides a clean configuration.
Try WPS Office for Reliable Spreadsheet Management
If Microsoft Excel's form controls are causing persistent cross-sheet errors and bugs, consider switching to WPS Office. It provides a highly compatible, free, and lightweight alternative with a familiar interface that handles complex worksheets seamlessly.

Frequently Asked Questions
Why do all my Excel option buttons select at the same time?
This happens when multiple option buttons are not separated by Group Boxes. Excel treats all option buttons on a single worksheet as one large group unless they are physically enclosed in separate Group Box form controls.
How do I fix a cell link that changes data on the wrong sheet?
Right-click the option button and select Format Control. Check the 'Cell link' field on the Control tab. If it contains a sheet name (like 'Sheet1!$D$4') instead of just a local cell reference (like '$D$4'), it will always update the original sheet regardless of where the button is located.
What is the difference between Form Controls and ActiveX Controls in Excel?
Form Controls are simpler, built-in objects that interact directly with cell references and are widely compatible. ActiveX Controls offer more advanced programmatic customization via VBA but can be prone to security restrictions, scaling issues, and compatibility bugs across different Excel versions.




