Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Refresh capturing rows returned to display progress
I have a excel file that access external data from a database. Sometimes
refreshing these queries takes 30+ seconds. How can I capture the rows being returned by the refresh? Sometimes I see these values displayed in the status bar, but only if I allow background refresh. I would rather not do a background refresh and to display them in a progress bar. Where can I find these refresh properties? Thanks you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query doesn't add/delete data in rows on refresh | Excel Discussion (Misc queries) | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
How do I limit the rows returned into Excel from a query | Excel Programming | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |