Hi Everyone...

I'm trying to retrieve data from Microsoft SQL Server To Microsoft Excel using MS Query (MSQRY32.EXE).

I want my end user to be able to change parameters in the query.
When I use parameters in the where clause (for example: WHERE XXX=?) I get the data succesfully, BUT when I try to use parameters in Stored Procedurs I always get the same message : "Parameters are not allowed in queries that can't be displayed graphically".

I tried MS Query Help, and it says I supose to run the procedure with hard coded values instead of parameters, save it, and then change the parameters to "?" (See image for details), BUT I GET THE SAME MESSAGE...

If anybody can help, i will appreciate it.