Hi there,

I have a workbook with 10 worksheets, one of the worksheets asks the
user what data to retrieve so I could filter the information. Based on
what the user enters, I need to refresh the corresponding worksheet.
Right now I'm using "ThisWorkbook.RefreshAll" but that takes too much
time to refresh since almost all the worksheets connect to an external
database.

Is there an easy way to refresh just one worksheet? It's not a pivot
table so I can't use the methods for pivot tables. I really appreciate
any suggestion you could give me. Thanks!


CT