Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing a worksheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing a worksheet
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing pivot table from different worksheet | Excel Programming | |||
Worksheet Function not refreshing | Excel Programming | |||
refreshing or repainting worksheet | Excel Programming | |||
Refreshing a Worksheet | Excel Programming | |||
Refreshing a Worksheet | Excel Programming |