Forum Discussion
Solved
Excel Online Checkbox COUNTIF Issue – Checkbox State Resets Unexpectedly
Hi everyone,
I'm experiencing an issue with checkboxes in Excel Online. I have a table where I use checkboxes (TRUE/FALSE) in five rows, and below them, I use the following formula to count how many checkboxes are checked:
=COUNTIF(F1:F5,TRUE)
However, when I check a box, the counter briefly updates (e.g., from 0 to 1 if only one box is checked) but then immediately resets back to 0 within a second, as if the checkbox is being unchecked in the background.
This behavior does not occur in the offline (desktop) version of Excel, where everything works as expected. Additionally, after reloading the page, sometimes the checkboxes reset to an unchecked state, and other times the counter updates correctly.
Is there a known issue with checkboxes in Excel Online, or is there a setting I might have misconfigured? Any advice would be greatly appreciated!
Thanks in advance.
I've noticed a problem, too. An easy workaround is to type 'false' or 'true' rather than checking the box. It's a good idea to send feedback about this so Microsoft hears about it.
3 Replies
I've noticed a problem, too. An easy workaround is to type 'false' or 'true' rather than checking the box. It's a good idea to send feedback about this so Microsoft hears about it.
Some other people shared similar problem. Looks like a bug in Excel for web. Workaround, as Kidd_Ip suggested, to use any suitable volatile function. That could be OFFSET. That could be
=COUNTIFS(F1:F5, TODAY()=TODAY() ), whatever, depends on situation.
Try below workaround:
- Double-click the formula cell: Sometimes, double-clicking the cell with the formula can force it to update.
- Use volatile functions: Adding a volatile function like OFFSET() might help. For example, you could try modifying your formula to:
=COUNTIF(OFFSET(F1:F5, 0, 0), TRUE)- Refresh the page: Reloading the page might temporarily fix the issue, although it's not a permanent solution.
- Use Excel Desktop: If possible, using the desktop version of Excel can avoid this issue altogether.
