Hello,

I have a PivotTable Report Filter. When a user closes the workbook, there may be "(Multiple Items)" selected in the ReportFilter/PageField/PivotField.

I need a line of code that will either select ALL items in the PivotTable, or will just disable "Select Multiple Items" (which selects All by default.

Any ideas?