The macro "repoNewquery cannot be found" in SAP BW BEx

[Former Member]

Hi,

when i attempt to open BEx analyzer, the following error message is displayed in SAP BW 3.5 NW platform.

"c:\programfiles\SAP\frontend\BW\SAPbex.xla!repoNewquery'

cannot be found.

I tried in the tool menu bar of MS excel to change the security status of the macro to the medium instead of high as was suggested in the pop up screen help. But it was of no use as i got the above error after changing .

Any suggestions folks?

Thanks,

Ravi

[Former Member]

Go to c:\programfiles\SAP\frontend\BW.

OPen the file SAPbexc.xla.

If click "Start" button it will tell which components are not installed properly.

Check the 2 sheets PC as well as server.

One more thought : GO to control panel-Add/Remove Programs and RUN the Microsoft Office Repair.This will repair all the corrupted dlls.

Regs

Gopi

Assign points if it helps.

[Former Member]

Hi,

I think you are not able to open the analyzer to create a new query....well may be any file of .xla may be currupted or missed. I believe you need to install BEx frontend once again.

Hope this helps you.....