title: Excel Sql throws Too few parameters error when Sql run in Excel read only mode
body: <p>I have an excel sheet where i am loading data into "Data" Sheet from oracle through ODBC. and then applying excel sql to filter some data </p>
  
  <p>Note: i am working on server machine so can not paste entire code. but whatever i put is 100% correct.</p>
  
  <pre><code>'Load Data Sheet
  Sql = Select * from oracleTable
  . . . 
  set rs1 = commandData.Execute() 'record set
  'Then code to store rs1 values in to Data Sheet...
  .
  .
  'Apply filter in Excel 
  query = select col1,col2,col3 from [Data$A1:IV100] where col1='10'
  set rs = commandData.Execute() 'record set
  </code></pre>
  
  <p>which returns proper result when opened in write mode.
  But, when i put the sheet in read only mode for my users to protect the content of the sheet. 
  It works to load data from oracle then It shows error when i execute the filter excel sql at line.</p>
  
  <pre><code>   set rs = commandData.Execute() ' Error at this line when opened in read only mode
  </code></pre>
  
  <p><strong>Error:</strong></p>
  
  <blockquote>
    <p>[Microsoft][ODBC Excel Driver] Too few parameters. Expected 1</p>
  </blockquote>
  
  <p>Is it something like when the excel is opened in read only it opens in Temp directory , so while executing excel query , is it struggling to find correct sheet to apply sql ?</p>