Filter: Cannot apply filter. Possible cause: some of the columns in selected range $A$9:$E$14 are empty

Thanks in advance, I am getting errors while filtering in Excel file,I have to check out filters and add or remove unwanted filters from Excel template
![image|690x480](upload://1n0bcnZBfS9svWcuJu8jphCxqrH.png)

@Pratiksha_Mahajan,

You should be applying filter on Headers and while doing that make sure there are no empty column headers.

To Clear any existing filter you can use Filter activity and checkbox the property: Clear any existing filter

Thanks,
Ashok :slight_smile:

image
as per the above screenshot of the table I have filters in rows and columns also and no empty column headers are present

@Pratiksha_Mahajan,

This is Pivot Table you are trying to filter. UiPath provided out of the box activity that is Activities - Filter Pivot Table

Use this for filtering.

Thanks,
Ashok :slight_smile: