I have a workbook that has a few dozen checkboxes. Almost all of these checkboxes are linked to a True/False value in a different cell, though I don't think that necessarily matters. I've seen it happen with unlinked checkboxes. We're testing 2016 versions for an organization-wide rollout and this is a blocker. The end users are not tolerant of malfunctions.
Sometimes checking the box is fine, but often it is frustratingly hard to get it to register the click. Although I have seen it in OS X Maverics (10.11.x), it seems markedly worse in Sierra (10.12.2). It sometimes takes 4 or more clicks for it to register.
This happens on multiple machines with the latest version of Excel 2016 - 15.29.1. At first I thought it was because the workbook was created in 2011, but it happens even with a brand new workbook.
Steps to reproduce:
1) Create a brand new workbook
2) From the Developer Tab (once enabled) - add a checkbox.
3) Link the checkbox to a cell under Format Control
4) Start clicking.. see what happens.
The success rate of a click varies widely in my testing. If it doesn't fail right away, just keep doing stuff in the workbook and try again.
I have tried every setting under "format Control". I have also tried linking to a VBA procedure rather than using the format control link to a cell. It made no difference.
Here's a video displaying the problem. The circle indicates a system-registered mouse click. (The Button (A2) works fine, I just put that in for comparison.)
https://www.dropbox.com/s/zovf3t6uqj96rc2/ClickFail.mov?dl=0
If anyone has encountered this and has a way to fix it, let me know. I'm running a base-line system with no special fonts or anything.
Thanks.