Skip to Content
Former Member
Jul 01, 2007 at 02:26 AM

Detach Query


Hi All:

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.