PivotFilters.Add2

[MNBUARQUE]

Hi !!

What is the difference between
PivotFilters.Add2 and PivotFilters.Add

I have already recorded a pivot table filtering process and sometimes I've gotten a PivotFilters.Add2 recorded and sometimes i've gotten PivotFilters.Add

BR

 

[RoryA]

Add2 will only work in Excel 2013 (or later!). I'd guess either it's a filter unavailable in previous versions, or perhaps you're using the Data Model when the Add2 gets recorded.

 

[MNBUARQUE]

Add2 will only work in Excel 2013 (or later!). I'd guess either it's a filter unavailable in previous versions, or perhaps you're using the Data Model when the Add2 gets recorded.

Thanks a LOT RoryA ! it makes lots of sense;
When I record a filter in Excel 2013, sometimes, I get an Add2. And, if a try to run this recorded slice into excel 2010 it does not work at all !
Unfurtunatelly, on the oposit direction, when I replace a "add2" with a "add" , the macro works in Excel 2010 but stops working in Excel 2013 !!!!!

But....does somebody knows what is the difference between de new Add2 method and the old Add ?

BR