Advanced Filter Macro Running Slow

Hello,

Using excel 2010, I am trying to use a macro to run an advanced filter. However there are close to 39 000 rows and the entire macro takes about a minute to run. Is there any way to speed this up please?

Also, when I press escape while the macro is still running I receive a "advanced filter method of Range class failed" error, which is odd because the correct result still appears given enough time. Sorry I am still very new to VBA.

PHP Code: 

Sub Advanced_Filter()

    
    Application.ScreenUpdating = False


    Sheet3.Range("Table_Query[#All]").AdvancedFilter Action:= _
        xlFilterCopy, CriteriaRange:=Range("A2:AC3"), CopyToRange:=Range("A8:AC8") _
        , Unique:=False
    
    Application.ScreenUpdating = True

End Sub 


Hello,

Sorry about that. I cannot attach the file since it is sensitive information but I'll try my best to describe it. The table is pulled from a database through MS query and has 29 columns as well. There are also a lot of blank cells. The cells are all formatted as general except for a date column which is custom (to include hours). Most of the data is numbers. I initially thought it might be slow because it is from a database but that would not make sense since the advanced filter is taking the information from the table and so shouldn't have any connection with the database.

I do have other macros on the workbook (search box, clear). It might be slow because of how big the table is but there was an instance where it was filtering instantly but it did slow down again. I have a feeling that it might be because I defined the range as a table instead of an actual range since most of the examples I have seen use ranges. However, I need the range to by dynamic since I may need to edit the table from MS query, making it bigger or smaller.

I hope this helps!