3 Replies Latest reply on Dec 8, 2012 2:46 PM by Richard Leeke

    Quick Filter Checkbox/Radio Button confusion

    Richard Leeke

      I've just noticed that one of my workbooks has got itself confused about checkboxes and radio buttons for quick filters. A filter defined as a single-value list is showing with checkboxes (but behaving like a radio button list - you can only select one checkbox at once). A filter defined as a multi-value list displays as radio buttons (but you can select multiple buttons).

       

      SingleValueCheckbox.PNG

       

      MultiValueRadio.PNG

       

      MultiValueRadioPartial.PNG

       

      Has anyone else ever struck this? If so, did you find a way to fix it?

       

      I've tried redefining the filters as single/multiple and back again, but it didn't help. It's a big workbook with lots of sheets, so I'm not about to recreate it. I feel a bit of XML hacking coming on...