Excel Macro to Unfilter Data on Multiple Worksheets

See this macro which will unfilter data on multiple worksheets.

Sub Unfilter() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.AutoFilterMode = False Next ws End Sub

Just insert in a module and run it. It can be a useful tool in processing data for production.