I have the same problem. Excel creates a parameter for each "?" if finds in an SQL extract query used to populate an Excel table from Oracle. My query's WHERE clause initially contained six different conditions (e.g. where ENAME = ? and EDEPT = ? ...). Now I want to streamline the query and reduce the number of parameter-driven conditions from six down to two, but the parameters interface (the Parameters button at the bottom of the table's External Data Properties, Connection Properties, Definition tab) still thinks I have six parameters and will not let me leave without pointing each one at a cell.
As best I can tell, parameters are assigned sequentially, top-to-bottom for each ? found in the query script, and any extras are just ignored, but I'm not sure and would love to remove them. How is that done or is do I have to build a new workbook to do it?