After I am done creating a query and running it in excel I want to turn that sheet into values. I tried to detach but when I do that it detaches the query for all the sheets which is not what I want. If I click remove query then it eliminates all the values in the sheet.
Is there anyway to detach a query in one sheet so that the values are still maintained. I know that I can copy paste special values into the same sheet but I was wondering if the Business Explorer has a way to turn a sheet into values.