Spreadsheet populated by MS Query, can I force it to REFRESH whenit opens?

[Mike Hanby]

Howdy,

I have a spread sheet that has all of it's contents populated via MS
Query to a MySQL database.

Is there any way to have a REFRESH automatically done each time the
spread sheet is opened?

Thanks, Mike

[Nick Hodge]

Mike

Right click on the recordset and select 'data range properties...' and
select 'Refresh Data on File Open'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"Mike Hanby" <[email protected]> wrote in message
news:[email protected]...
> Howdy,
>
> I have a spread sheet that has all of it's contents populated via MS Query
> to a MySQL database.
>
> Is there any way to have a REFRESH automatically done each time the spread
> sheet is opened?
>
> Thanks, Mike

[Mike Hanby]

Thanks Nick, that was easy enough :-) Works great.

Nick Hodge said the following on 06/20/2005 16:32:
> Mike
>
> Right click on the recordset and select 'data range properties...' and
> select 'Refresh Data on File Open'
>