Hello,
My macro that is normally filtering a pivot table and working just fine just got to a case where it isnt able to apply a filter because the filter gives no data(filter is greyed out but can be used manually)

total is the name of the table and area is the mentioned filter

Please Login or Register  to view this content.
Normally it checks a separate Workbooks Pivot Table, Filters it for fixed Fields and pastes the value into the active worksheet.
But now it just pastes the value from the unfiltered table because it doesnt apply the greyed out filter even though you can select it manually.
the rest of the code is also tested by using an area with data in it where it worked just fine. The problem is definetly the macro not aplying the filter.

Is there a way to make sure, that i just get a 0 as return value in a case like this?