Hi,
I'm running "Data"-> "Get external data" to connect via ODBC to OracleDB. The Query returns a number to one cell, lets say A1.
I need to run a different query to cell A2, but it doesn't let me; instead it thinks that cell is assigned to the first query and it only gives me the option to Edit the query or refresh it. I have to go to cell A4 to be able to create a new query.
Evem if I do that, sometimes when I refresh my queies, the second query moves from cell A4 to cell A3.
How can I solve the problem and be able to run different queries to consecutive cells?
thanx
I'm running "Data"-> "Get external data" to connect via ODBC to OracleDB. The Query returns a number to one cell, lets say A1.
I need to run a different query to cell A2, but it doesn't let me; instead it thinks that cell is assigned to the first query and it only gives me the option to Edit the query or refresh it. I have to go to cell A4 to be able to create a new query.
Evem if I do that, sometimes when I refresh my queies, the second query moves from cell A4 to cell A3.
How can I solve the problem and be able to run different queries to consecutive cells?
thanx