And we got the cell reference to work in 2007 through the parameter dialog not by entering the direct cell reference. I think the SQL you enter goes straight to...

I my experience the syntax that as consistently worked is:

{Call storedprocedure (?,?)}

So the parameters had to be in parentheses and the entire statement had to be preceded with Call and...

The syntax for calling a SQL Server stored procedure with parameters in Excel 2007 (maybe even for 2003, not sure): {Call sp_name(?,?)}

You can add a connection through ms query, as...

Hello,

I just wanted to note that--at least in Excel 2007--you can use the call syntax to call stored with parameters from Excel.

{Call ?,?,?,?,... ?} works just fine.

You're warned...