Excel Refresh Query

[seannewtoexcel]

Hi All

Quick question, I have three sheets in an excel file, two of which have sql queries running off them, currently I have to go into the sheet and right click to update the information (date=?) so I manually input the date inoder for the refresh, I want the date pop up box to appear when I open the file as it is the same date used for both sheets, how would I do that?

Thanks for the help.

Sean