I had a sheet with Data-Get External Data query, but now all that i
gone, but the query is still there so how do I delete it off the shee
because if someone runs it, it will mess everything up.

Thank

--
vpr8
-----------------------------------------------------------------------
vpr80's Profile: http://www.excelforum.com/member.php...fo&userid=1578
View this thread: http://www.excelforum.com/showthread.php?threadid=31439

try insertnamedelete the name(s) that refer to the query

--
Don Guillett
SalesAid Software

"vpr80" wrote in message
...

I had a sheet with Data-Get External Data query, but now all that is
gone, but the query is still there so how do I delete it off the sheet
because if someone runs it, it will mess everything up.

Thanks


--
vpr80
------------------------------------------------------------------------
vpr80's Profile:
http://www.excelforum.com/member.php...o&userid=15788
View this thread: http://www.excelforum.com/showthread...hreadid=314396

hi,
click in the range where the exteranl data use to be.
dataget exteranl datadata range properties
NOTE: if data range properties is not enabled, you're not
in the query range. re-position the cell pointer until
data range properties is enabled.
when the data range property sheet comes up,
uncheck save query definition. you will get a warning.
click ok. click ok.
guery gone.
wave by-by

-----Original Message-----

I had a sheet with Data-Get External Data query, but now
all that is
gone, but the query is still there so how do I delete it
off the sheet
because if someone runs it, it will mess everything up.

Thanks


--
vpr80
----------------------------------------------------------
--------------
vpr80's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=15788
View this thread:
http://www.excelforum.com/showthread...hreadid=314396

.