Re: Refreshing a worksheet

Tech-Archive recommends: Fix windows errors by optimizing your registry

Cecille wrote:
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 work***.
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 work***? 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 *** here" with the real name of
your *** (with quotes, as I did...).

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


.

Quantcast