Home › Forums › Power Pivot › Using VBA to filter Pivot Table from PowerPivot Tagged: filter, pivot table, vba This topic contains 1 reply, has 2 voices, and was last updated by tomallan 4 months, 4 weeks ago. Viewing 2 posts - 1 through 2 (of 2 total) Author Posts September 20, 2018 at 10:58 am #10655 bohus.uhrinParticipant Started: 1Replies: 0Total: 1 Hello, I recorded macro which should clear filter in my pivot table based on power pivot datamodel. It looks like this, however, it doesnt work, could anyone help? ActiveSheet.PivotTables(“PivotTable7”).PivotFields(“[Database].[Employee name].[Employee name]”).ClearAllFilters September 20, 2018 at 3:47 pm #10659 tomallanKeymaster Started: 7Replies: 2552Total: 2559 I see no reason why it would not work, given the information (your data model has a table called Database and a field called Employee name) Is the anticipated sheet truly the active sheet? Have you stepped through your VBA code and made sure the line of code has executed? Is there any code that subsequently executes and restores the filter? For additional help, please put up an example workbook with pivot and VBA code. Author Posts Viewing 2 posts - 1 through 2 (of 2 total) You must be logged in to reply to this topic.