How can I Invoke a filter automatically

[busyman5_au]

I have used a filter and list formatting to create the worksheet the way
I want it and the data refreshes (from external links) when I open the
workbook.

But the advanced filter has not been applied.. it works if I click on
it in the menu bar.

How can I re-apply this filter automatically when The data is refreshed
?

Thanks

 

[CLR]

You might just record a macro while going through the steps to activate the
filter, and then just run the macro when the updating is completed.

hth
Vaya con Dios,
Chuck, CABGx3