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