hi
forgot to mention. see this site on getting started.
http://www.mvps.org/dmcritchie/excel/getstarted.htm

regards
FSt1

"Andy" wrote:

I have a worksheet with multiple external queries linked to Access. I want a
user to be able to refresh all external data, but just within this one
spreadsheet and not across the whole file.

Is there any VBA that I can put behind a button just to refresh all queries
within this one worksheet?

Thanks