ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   remove MS Query from Excel (https://www.excelbanter.com/excel-discussion-misc-queries/182452-remove-ms-query-excel.html)

luscioussarita

remove MS Query from Excel
 
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

FSt1

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



All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com