Parameters are not working in embedded SQL Query in Excel

[Ambition]

Until now, I have always used MSQuery to create queries with parameters, and then embedded the query into an Excel spreadsheet. This would allow me to anchor my parameters to certain cells on the spreadsheet. My report users could then change the values in those cells and click a button to refresh the query data. This works wonderfully with simple queries. Now I have created a very complex query, specifically a query that uses a subquery as its SELECT FROM. When I try to set up my parameters in MSQuery for this query it says "parameters are not allowed in queries that can't be displayed graphically." Without being able to put parameters in my query, I can't automate this using Excel. Is there some other way to accomplish what I want to do.
My SQL is:

• SELECT UM00163T.METER_NO, UM00100M.LOCATION_ID_CUSTOM, UM00163T.READ_DTM, UM00163T.READ_AMTFROM UM00100M, UM00163T,
• (SELECT UM00163T.METER_NO, MAX(UM00163T.READ_DTM) AS READ_DTM FROM UM00163T GROUP BY UM00163T.METER_NO)TEMP
• WHERE UM00100M.LOCATION_NO = UM00163T.LOCATION_NO AND UM00163T.CYCLE_CD=? AND UM00163T.METER_NO = TEMP.METER_NO AND UM00163T.READ_DTM = TEMP.READ_DTM
• ORDER BY UM00100M.LOCATION_ID_CUSTOM

[JyotiT]

Create a VIEW on the database server containing the SQL. Modify your Excel app to query the VIEW rather than the base tables.

[Go!pee]

I understand that in the Excel-e are creating a sheet, it is something you write, and now ready to table. Anywhere, but the methods available to the public, without setting different mySQL and SQL Server.