Hi Everyone!

I have a very strange issue. I have one user that is unable to check/uncheck checkboxes in an Excel spreadsheet. However I am able as well as other users in this same sheet. It is not a shared sheet and is saved locally to the computer.

Office version is 2013 and I have already run a repair on office but this has not resloved the issue.

Any ideas??

Thanks for your help,
Jen

Hi Jen,

I wonder to know did you use the same version of office. And please tell me which kind of checkbox the user cant use, if the checkbox was inserted by user or it existed in the office itself (like the checkbox in Options-General)?

If the checkbox is inserted by user, please create a new spreadsheet and insert a checkbox to check if it works fine. Please give me feedback if it doesnt work.

Then, you can try to edit this spreadsheet, check if you can edit this spreadsheet. You cant edit it you may get a message bar PROTECTED VIEW. By using protected view, you can only read a file and see its contents. You can click Enable Editing on the message bar to edit this spreadsheet.

To get more information about Protected View, you can refer to this link:

https://support.office.com/en-us/article/What-is-Protected-View-d6f09ac7-e6b9-4495-8e43-2bbcdbcb6653?ui=zh-CN&rs=en-US&ad=CN

On the other hand, you can edit the spreadsheet but not check the checkbox. The form control might be damaged in the users computer. Form control stop working after December 2014 updates, and Hotfixes for this issue have been released in the March 2015 Updates for Office 2007, 2010 & 2013. You can refer to this link to solve this issue:
http://blogs.technet.com/b/the_microsoft_excel_support_team_blog/archive/2014/12/13/forms-controls-stop-working-after-december-2014-updates-.aspx

If the issue still exists after these methods, please tell me. I am glad to help and forward to your reply.

Regards,