Excel Checkboxes are not working in Office 365 for some users

Question

Excel Checkboxes are not working in Office 365 for some users

Drew H 15

A few of our users are unable to see checkboxes in Excel Online and instead see True or False instead.

Not all users, but at least two have this issue while others see Checkboxes.

Drew H 15 Reputation points

2024-08-14T15:48:20.87+00:00

Found that users who can see the check boxes have the Checkbox option under Insert -> Controls, while I myself do not have this option. Is there a way to add it to Excel 365?

2 answers

Your answer

Drew H 15 Reputation points

2024-08-14T15:48:20.87+00:00

Found that users who can see the check boxes have the Checkbox option under Insert -> Controls, while I myself do not have this option. Is there a way to add it to Excel 365?

Answer 1

Muhammad Ibraheem Ishtiaq 155

Ensure that all users have the same level of permissions and that the file is shared correctly.
- Check if the issue persists in the desktop version of Excel. If the checkboxes appear correctly there, it confirms it’s an issue specific to Excel Online

Drew H 15 Reputation points

2024-08-07T15:19:23.8033333+00:00
Checked and each user has an E1 license and the same permissions.

The document is shared from one user's OneDrive to the others with each user having Edit access.

Downloading the file to the desktop version does not fix the issue.
kguntaka 6,865 Reputation points Microsoft External Staff

2024-08-09T04:06:07.2733333+00:00

Hi Drew H,

Make sure everyone is using a browser that is up-to-date and supported. Browser issues can sometimes cause problems with how Excel Online looks. Have the users who are having trouble clear their browser’s cache and cookies, as this can help fix display issues. Check that everyone has the same settings in Excel Online, since different settings can make things look different. Ensure everyone has the latest updates for Office 365, as updates might be released at different times. Try deleting and then recreating the checkboxes in the document, which can sometimes fix display problems.
kguntaka 6,865 Reputation points Microsoft External Staff

2024-08-10T05:43:20.1+00:00

Hi Drew H,

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution.

Answer 2

Jiajing Hua 18,130 Moderator

Hi @Drew H

Could you please tell us how did you insert the check box?

If you inserted it via: Insert > Controls > Checkbox, please refer to Muhammad Ibraheem Ishtiaq's suggestion. You may also let these users change a browser for a check.
If you used check box controls from Developer tab, here is a link: https://support.microsoft.com/en-gb/office/form-controls-9f201e46-8f6b-4a9d-a320-f44b28088cb0#ID0EBH=Web, you may have a look. Currently, we can't use check box controls in Excel for the web. If you see an "Edit in the browser?" or "Unsupported features" message and choose to edit the workbook in the browser anyway, all objects such as check boxes, are lost immediately.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

kguntaka 6,865 Reputation points Microsoft External Staff

2024-08-07T16:37:57.12+00:00

Hi Drew H,

I wanted to check if you had the chance to review the information that was provided by @Jiajing Hua-MFST. Please feel free to contact us if you have any more queries. If I have provided a prompt response, you may provide your vote/feedback so that other community members can benefit from the information.
Jiajing Hua 18,130 Reputation points Moderator

2024-08-15T00:47:02.82+00:00

Hi @Drew H

Thanks for your back.

Please check the Office update channel and version number. You may go to File > Account, check this information under Product Information.
Drew H 15 Reputation points

2024-08-15T14:02:45.2966667+00:00

I clicked File, but can't find the Account option.
Jiajing Hua 18,130 Reputation points Moderator

2024-08-16T08:13:05.4466667+00:00

Hi @Drew H

My apologies, there is no version number for Excel online.

But according to the image you shared, it seems that your Excel online version does not get this new feature.

As Checkbox control is a new feature, it is currently rolling out to all Excel for the web users. In my opinion, you need to wait patiently to receive this feature update.

For more, please refer to this link: https://techcommunity.microsoft.com/t5/excel-blog/introducing-checkboxes-in-excel/ba-p/4173561#:~:text=Checkboxes%20in%20Excel-,Availability%3A,-Don%E2%80%99t%20have%20it

Thanks for your understanding.
kguntaka 6,865 Reputation points Microsoft External Staff

2024-08-17T00:46:56.94+00:00

@Drew H,

Regarding your issue, any update?