remove MS Query from Excel

L

luscioussarita

I put in a MS Query into Excel but I had two previous one in the spreadsheet.
How do I remove it from the sheet?

Sarita
 
F

FSt1

hi
right click the MSQ range and from the pop up select "data range properties"
on the data range property box, at the top, uncheck "save query definition"
you will get a warning about permanently removing the query. chick yes.
gone.

Regards
FSt1
 
Top