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

.