View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default remove MS Query from Excel

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

"luscioussarita" wrote:

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