S
ScottSut
If I previously have 500 rows and a refresh returns 200 rows, CTRL END or the
subtotal functions still thinks there is 500 rows.
subtotal functions still thinks there is 500 rows.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
S
Scott Sutherland
Thanks Frank .... I'll use the suggestion code to make my own macro. You'd
think this would be an option available in the External Data properties.
think this would be an option available in the External Data properties.
T
Tom Ogilvy
Did you save the workbook after refreshing the query?
Did that change anything - just curious.
Did that change anything - just curious.
S
Scott Sutherland
Oh Brother ... it sure did ... save the worksheet and the active cells must
get refreshed ... Thanks for this Tom.
get refreshed ... Thanks for this Tom.