Reset Filter with query

[itsgrady]

I have a query that runs perfectly in Excel. However, after the query is executed, users often filter the results. When I refresh the data source and run the query again, it executes without issues, but the results remain filtered based on the last user's filter settings.

Is there a way to automatically reset the filters so that all rows are displayed after I refresh the query results?

Thank you for your help.

 

[AlienSx]

Table Design -> Properties -> uncheck Preserve column sort/filter/layout

 

[itsgrady]

Table Design -> Properties -> uncheck Preserve column sort/filter/layout

Thanks for the quick response and quick fix. I looked under the other properties but I did not check the table properties. Thanks for pointing me in the right direction.