Hi,

I am running reports, with fix filters, so when I open the workbook I am forcing all pivot tables to use certain filters

For example

Please Login or Register  to view this content.
The problem I am facing is some filters has no DATA like above statement there is no Adhoc == IsAdhoc, and when there is such a condition I am getting an VBA error.

I have been thinking but was not able to find a solution. Maybe displaying zero or hiding the pivot table if that is the condition. I am not sure how to get it done and would appreciate the help.

Thank you!