Excel Checkboxes Do Not Save in Microsoft 365 Workbook: Fix

You add checkboxes to a worksheet, save the file, and reopen it only to find the checkboxes missing or reset to their default state. This problem usually occurs because Excel 365 saves the checkbox state as a property of the workbook, but the file format or a damaged add-in prevents the state from being stored correctly. This article explains why checkboxes lose their state and provides three reliable methods to fix the issue.

Why Excel 365 Checkboxes Reset After Saving

Excel 365 supports two types of checkboxes: Form Controls and ActiveX Controls. Both store their checked state as a property of the control object inside the workbook. When you save the file, Excel writes these properties into the file structure. If the file is saved in the default Excel Workbook (xlsx) format, the control properties may not be fully written because the .xlsx format is designed for data and formatting, not for VBA or ActiveX control persistence. The .xlsm format, on the other hand, explicitly supports macro-enabled content and control state storage.

A second cause is a corrupted or conflicting COM add-in. Add-ins that hook into Excel’s save event or modify the user interface can intercept the save operation and accidentally strip control properties from the file. This is especially common with older add-ins not updated for Excel 365.

A third cause is the use of ActiveX controls instead of Form Controls. ActiveX controls have more features but are more prone to state-loss bugs in Excel 365, particularly when the workbook is opened in different versions of Excel or on different operating systems.

Steps to Prevent Checkboxes From Losing Their State

Use these methods in order. Test after each method by saving, closing, and reopening the workbook.

Method 1: Save the Workbook as an .xlsm File

1. Open the workbook with the checkboxes
   Make sure all checkboxes are set to the state you want to save.
2. Go to File > Save As > Browse
   The Save As dialog box opens.
3. Change the file type to Excel Macro-Enabled Workbook (xlsm)
   Click the Save as type drop-down list and select Excel Macro-Enabled Workbook (xlsm).
4. Click Save
   Excel saves the workbook in .xlsm format. If a warning about macros appears, click Yes to confirm.
5. Close and reopen the file
   Verify that the checkboxes display the state you set before saving.

Method 2: Replace ActiveX Checkboxes With Form Controls

If the .xlsm format did not fix the issue, the checkboxes are likely ActiveX controls. Replace them with Form Controls.

1. Delete the existing ActiveX checkbox
   Right-click the checkbox, select Cut or press Delete.
2. Enable the Developer tab if it is not visible
   Go to File > Options > Customize Ribbon. Under Main Tabs, check Developer and click OK.
3. Insert a Form Control checkbox
   On the Developer tab, click Insert. In the Form Controls section, click the Check Box icon (the one with a check mark).
4. Draw the checkbox on the worksheet
   Click and drag to create the checkbox where the old one was. Right-click the new checkbox and select Edit Text to change the label.
5. Link the checkbox to a cell
   Right-click the checkbox, select Format Control. On the Control tab, enter a cell reference in the Cell link box. Click OK. The linked cell shows TRUE when checked and FALSE when unchecked.
6. Save the workbook as .xlsm
   Repeat the steps in Method 1 to save the file in .xlsm format.

Method 3: Disable Conflicting COM Add-ins

1. Open Excel in Safe Mode
   Press and hold the Ctrl key, then double-click the Excel shortcut. When the prompt appears, click Yes. If the checkboxes save correctly in Safe Mode, an add-in is the cause.
2. Open COM Add-ins settings
   Go to File > Options > Add-ins. At the bottom, in the Manage drop-down, select COM Add-ins and click Go.
3. Clear all checkboxes for third-party add-ins
   Uncheck every add-in that is not a Microsoft product. Do not uncheck Microsoft Power Map for Excel or Microsoft Power Pivot for Excel unless you are certain they are not the cause.
4. Click OK and restart Excel
   Reopen the workbook and test the checkboxes. If they now save correctly, re-enable add-ins one at a time to find the specific culprit.

If Checkboxes Still Reset After Applying the Main Fixes

Checkbox state reverts when the workbook is opened on a different computer

This happens when the workbook uses ActiveX checkboxes and the target computer has a different version of Excel or missing controls. Replace ActiveX checkboxes with Form Controls as shown in Method 2. Form Controls are backward-compatible and do not rely on ActiveX component registration.

Checkboxes disappear entirely after saving

The workbook may have been saved in a format that does not support controls, such as CSV UTF-8 (csv) or Excel 97-2003 Workbook (xls). Always use Excel Macro-Enabled Workbook (xlsm) for files with checkboxes. If you need to share the file with users on older Excel versions, consider linking the checkbox to a cell and using the cell value (TRUE/FALSE) as a workaround.

Checkbox state resets after a VBA macro runs

A macro that clears the worksheet or reinitializes controls can overwrite the saved state. Check the VBA code for lines that set CheckBox.Value = False or CheckBox.Value = xlOff. Comment out or modify those lines to preserve the user’s selection.

Form Controls vs ActiveX Controls for Checkbox Persistence

Item	Form Control Checkbox	ActiveX Checkbox
File format required	.xlsm or .xlsx	.xlsm only
State saved correctly in Excel 365	Yes	Frequently fails
Compatibility with older Excel	Good	Poor (requires ActiveX registration)
Can be linked to a cell	Yes	Yes
Supports VBA events	Limited	Full

For most business workbooks, Form Controls are the safer choice because they do not depend on ActiveX and retain their state reliably across saves and versions.

You can now fix checkboxes that fail to save in Excel 365 by switching to the .xlsm format, replacing ActiveX controls with Form Controls, and disabling conflicting add-ins. Next time you create a checkbox, use the Developer tab and insert a Form Control from the start. For an extra layer of safety, link each Form Control checkbox to a hidden cell and use that cell’s value in formulas instead of reading the checkbox state directly.