Refreshing a worksheet

[Cecille]

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

 

[Franz Verga]

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!

Hi Cecille,

I think you could use something like this:

Worksheets("Name of your sheet here").Calculate

Where you have to sobstitute "Name of your sheet here" with the real name of
your sheet (with quotes, as I did...).

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy