Refering to a cell in Where Clause of External Data Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created an External Data Range:
Data|Import External Data|Import Data
I'm connecting to an Oracle system and using the Query mode (vs. SQL or
Default). I can right-click and edit the query to change my where clause,
but I have a lot of these on the worksheet and would like to use a value of
some other cell on the worksheet in the where clause. That way I can change
that cell and "Refresh All"

My where clause looks like "where id in (?)" but I'd like to say "where id
in (Sheet1!B3)"

I read that someone suggested putting [whatValue?] in the parameter spot --
but that didn't work for me. Perhaps because I am not using SQL*Server or
Access?
 
Right click on a cell in the query and select parameter from the popup
menu. In the resulting dialog at the bottom, click the option button to
specify a cell. Put in

=Sheet1!$B$3

look at the additional check box below that if desirable. (about
automatically refreshing if the value in the cell changes).
 
Back
Top