I have a MS Query to retrieve data from SQL server database through ODBC
Connection

My user needs to right click to refresh data every time.

Is it possible to write some code to refresh the MS Query when open the
spreadsheet?

Also, May I pass parameter from spreadsheet?

Any information is great appreciated,