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

  • Thread starter Thread starter Mike Hanby
  • Start date Start date
M

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
 
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
(e-mail address removed)
 
Thanks Nick, that was easy enough :-) Works great.

Nick Hodge said the following on 06/20/2005 16:32:
 
Back
Top