Hi all,

I have VBA code to filter multiple pivot tables. The code works, but only if before running the code I select the pivot filter drop-down menu on the spreadsheet (I can then click away, but I always need to do this step when opening the workbook

If I don't do this step, I get the following error:

"Run-time error '1004': Application-defined or object-defined error". It errors on this first line of code:

ActiveSheet.PivotTables("PivotTable1").CubeFields(26).EnableMultiplePageItems _
= True

Again, it works fine as long as I click on the spreadsheet pivot filter (don't need to actually select anything, just click the dropdown) and click away again! Confused as to what code I need to put in to make it work consistently. Thanks!