on 09-03-2009 10:23 AM
Hello experts,
when I try to open a query in BEx Analyser I get this error message for each Item of the Query:
-
Diagnosis
The BEx Analyzer cannot generate VBA code due to the security settings.
System Response
VBA code is not generated.
Procedure
Choose Tools -> Macro -> Security.
On the Trusted Publishers tab page, select Trust access to Visual Basic project.
Choose OK.
Close the BEx Analyzer and continue working as before.
Access to Visual Basic project is only needed when generating VBA code.
This only takes place in design mode or when 3.x workbooks are upgraded.
-
Of course I did exactly what was recommanded in the "procedure-section" of this error message. But BEx ist still not working!
I use SAP NetWeaver 7.0 together with MS Excel 2007
Thanks
Axel
Hi Axel
You might be using excel 2007 with Service pack. What we have normally seen if that Bex and Excel 2007 SP does not work well together. You might need to reinstall your excel version.
Thanks,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Axel,
If you are with Excel 2007 then to enable the Security Settings,you can go to
Excel 2007->MS Office Button(Top Left corner of the screen)->Excel Options->Trust Center->Trust Center Settings->Macro Settings->Check "Trust Access to VBA Project Object Model" checkbox
Rgds,
Murali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello experts,
I am an additional person interested in the way this issue was solved.
I confirm that the issue is coming from the SP2 of Microsoft Office (I have another environnement without the SP2 and everything works well), and I am in a situation where I can't remove the update.
Regards
Guillaume P.
EDIT :
Solution found : I applied the bi710sp10p_1001-10004472.exe patch
(downloaded via the download maanger : Support Packages and Patches - Entry by Application Group" SAP Frontend Components" BI ADDON FOR SAP GUI" BI 7.0 ADDON FOR SAP GUI 7.10)
Edited by: GUILLAUME PETIAUX on Apr 13, 2010 10:29 AM
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.