a worksheet within BEX Workbook is lost upon Query Refresh

Question: Hi Experts,

Need your help. I have another worksheet in a BEX Workbook, each time i refreshed..the computation that I did in separate worksheet is lost. Then, i have to redo the computations that i did manually.

What i want is even if refreshed the Query, the other worksheet shouldn't be affected, and it should be there still. Question: How to make it possible.

Hoping for your sharing ideas on this.

Thanks so much.

Answer:
Sofie, seen your profile and the other question posted,
I wonder if you just didn't forget to save your workbook as a workbook in BW,
looks like you re-launch the QUERY and not the WORKBOOK.

Ch
Copyright ?2007 - 2008 www.jt77.com