The Clear Filter action clears an existing filter in an Excel workbook. Only one filter can be running at a time, but no matter what column you target in the workbook, any filters that exist in the workbook are cleared.

Note: The Actions Quick Reference provides a complete list of actions that you can print for easy reference.

1. In the target Excel workbook, drag and drop the Target Selector onto the Targets list to display the available target options.

2. Continue to drag the Target Selector to the Column option and select any column.

   If this is the first time the workbook was targeted, Nintex RPA LE will attempt to create a workbook connection automatically. For more information about Microsoft Excel workbook connections, see Excel Connections.

3. Select Clear Filter from the Actions list.

4. If needed, adjust the Wait up to timing settings and enter the amount of time the action will wait for the desired response.

   • Do not wait
   • Wait up to
   • Wait forever

5. If needed, adjust the Run error task settings to fine tune how the action runs.

   • Run error task: A botflow containing an error task automatically runs the error task in the event of an error. If the botflow does not contain an error task, the botflow stops in the event of an error.
   • Stop on error: The botflow stops in the event of an error.
   • Ignore errors: The action is skipped in the event of an error and the botflow attempts to execute the next action.

6. (Optional) Add a Note to document special instructions or functionality.

7. Toggle the run switch to Run and click OK to execute and save the action.

Note: The run switch is set to Run by default. To create or modify this action without executing it, click the slider to change the option to Don't Run.  For more information, go to Action Builder.