http://support.microsoft.com/kb/213187/en-us
XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events

--
Regards,
Tom Ogilvy


"djd" wrote in message
...
I have a worksheet that is populated with data from an external source. I
need to go through the data on the worksheet and extract values that will
be
used in a couple of lists in the workbook after the data has been
refreshed.
The refresh on open option is turned on. I added the code to the workbook
open event but that results in the code executing prior to the prompt to
refresh the external data. Is there another event where the code should
be
located? Is there any other way that I can run the code after the refresh
of
the external data?