I have a pivot table that I'm refreshing based upon the values on a form.
Parameter is updated by combobox1 Specialty is updated by a multiselect
listbox and region is updated by combobox3. I've found that in order to
make the Specialty selections work for the pivot, I have to iterate through
the .PivotItems and make them all hidden, then I loop through the listbox to
determine what was selected. Using an array to store those values I then
unhide the .PivotItems saved in the array as selected items. This code
works if you build the pivot from scratch (via code) each time. However,
for this particular pivot it gives me the runtime '1006' because it is
saying that I can't hide everything, I need at least 1 selection. Has
anyone ever worked around this or think of a better way to deal with a
multiselect listbox as critera for a pivot?

Cheers,

Job