Excel 2005 Datasource

I have an Excel 2003 file with a SQL Server Datasource feeding the data.

Is there any way I can get the data to refresh on the file opening?
Larry Bristersr. DeveloperAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
Right-click the querytable, choose Data Range Properties and check the option to refresh on Workbook open.
Regards,
Rory
0
 
gjutrasCommented:
record a macro of the data refresh and save it with the name Workbook_Open in the workbook object(This Workbook) or edit it and move it to the workbook object. Then when you open the workbook this macro will run.
0
 
gtglonerCommented:
Try this code in your ThisWorkbook VBA environment window:

Private Sub Workbook_Open()

 ActiveSheet.RefreshData

End Sub
0
 
Larry Bristersr. DeveloperAuthor Commented:
rorya:
  I cannot believe that I didn't follow the first rule of Microsoft.  When in doubt right-click.

Points being awarded now.  Great job...and first too!
0
 
Rory ArchibaldCommented:
Glad to help - thanks for the grade.
Rory
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.