Hello Community, 

Does anyone know what is the right VBA method to iterate through all items in the Power Pivot table filter? 

I need to create a separate  copy of the master power pivot table on a separate sheet for each value of the power pivot table filter;  it seems like traditional methods like ‘PivotItems’ don’t work with power pivot. 

Thank you! 

​Hello Community, Does anyone know what is the right VBA method to iterate through all items in the Power Pivot table filter? I need to create a separate  copy of the master power pivot table on a separate sheet for each value of the power pivot table filter;  it seems like traditional methods like ‘PivotItems’ don’t work with power pivot.  Thank you!    Read More

​