Detach Query

[Former Member]

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.

Thanks,

[Former Member]

what do u mean by "turn a sheet into values"?

[Former Member]

I just want the sheet that is attached to a query to be detached of the query but to keep the values intact.

Therefore if lets say a value for an account number is 50,000 I want to remove the query but still preserve the value.

[Former Member]

Thats not possible, if you want to save as a workbook in a role and still doesnt have a query attached to it. That wouldnt make sense either. The way you want is as good as a local excel file saved on the hard disk with no query attachement. You cant do that in Bex, save the reesult set as a worksheet and still be placed on the SAP role