In my experience you cannot run a new query in the same range as a previous
query. Only a refresh is allowed of the previous query. Either delete the
range of the previous query or use a different, non-overlapping range.
Mike F
"Mahesh" wrote in message
...
Hi,
I am running SQL queries from excel and populate the sheets. I have a
problem when i am running the queries which create temp tables. After i
create temp table and run another query on that temp table (#temp1) it is
giving an error.

Can any one help on this