1) Close any existing excel session

2) Open your sap logon

3) Select your BW source system (For example WBP)

4) Enter the transaction code RAAOE and press "Enter"

5) Choose "Client Only" and click on the clock îcon to launch BW Analysis

You are now in eXcel, the next steps are exactly the same as when you open BW Analysis via eXcel. 

6) to open directly a core query choose the option : Query  then select it among your roles and run it.