How to uncheck filter data table


Have you selected Use filter option in Read Range Activity ?

If yes then uncheck and try then it will ignore filter and will read all the data.

It can be done once after getting the datatable
That is using excel application scope and read range activity we can get the datatable output named dt
And to filter all records without N/A value then this thread would help you

Cheers @Carla_Marie_Barte

The Use filter is uncheck

1 Like


Then it should read whole data.

But i want to uncheck just the #N/A

Then this would help us


@Carla_Marie_Barte I guess We just need to use Filter Datatable Activity and use Filter Operation as Does Not Contain ‘#N/A’. :sweat_smile:

I used that at first but it doesn’t work

oh :neutral_face:

@Carla_Marie_Barte What was the Result, It didnt Filter at All, or did it Filter some rows?

No nothings happen

I just want to uncheck the #N/A so that only the numbers will appear on the excel file

@Carla_Marie_Barte Can you tell us What are the Operations that you are performing currently

Use invoke vba for unselect #N/A

Sub Macro1()

’ Macro1 Macro

ActiveSheet.Range("$A$1:$A$13").AutoFilter Field:=1, Criteria1:="<>#N/A", Operator:=xlFilterValues
End Sub

choose your range accordingly by passing variables

@Carla_Marie_Barte Filter Datatable Will Just Filter the Datatable. It will not effect the Excel File :sweat_smile:
I think you need to use Filter Table instead of Filter Datatable if you want the Expected Output

dont do it

What will i put there???


put it there and paste it