Assigning pivot filter that doesn't exist breaks macro

The way I handle this is to use a helper cell in the spreadsheet to test if it filter is available. I use COUNTIF and if it's zero, I can't apply the filter, so I skip over it in the code.

Also, you cannot have all the items set to false. What you have to do is turn everything on, and then turn off what you don't want. You can't set them as you go along either. You might turn off A and it was the only thing turned on. The code doesn't know that you intended to turn B on later.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.