Prior to Excel 2007, when you did a "Select Multiple Items" on a drop down list (Report Filter) and chose only the items you wanted seen in the list, users would see "(Multiple Items)" in place of "All". When the clicked on the drop down list, the items they would see would then be ONLY the items that were chosen to be seen. Now, in Excel 2007, the same thing happens, but when users click on the drop down list, they see a check box next to all the items, and are not able to use the field any more for filtering. For example:
Report filter has 5 values. I chose "Select Multiple Items" and I say only show items 1 through 3. When users now go to use that drop down list, they can not simply click on "3" to eliminate 1 and 2, because all that will do is uncheck the check box.
I am looking for the multiple items to basically work more like pre-2007 version in this case.
Any ideas?
Thanks
Report filter has 5 values. I chose "Select Multiple Items" and I say only show items 1 through 3. When users now go to use that drop down list, they can not simply click on "3" to eliminate 1 and 2, because all that will do is uncheck the check box.
I am looking for the multiple items to basically work more like pre-2007 version in this case.
Any ideas?
Thanks