“Two possibilities exist: either we are alone in the Universe or we are not. Both are equally terrifying.”
Arthur C. Clarke.
Monthly Archives: September 2023
SAP Logon. Export to Excel. Microsoft has blocked macros from running because the source of this file is untrusted.
When you export a report from SAP to MS Excel this error may occur. New MS Office update prevents running unsigned VBA scripts.
You need to upload new templates to SAP. The problem is that SAP uses several templates for different cases. I found it for Report Writer and EHS Excel. The notes mentioned below might help you. You just need to download these new templates and upload them according to the notes information. In addition, you need to download new SAP certificates for digitally signed VBA scripts. It’s needed to upload to each workstation in Trusted Publishers. Group policy can be used to automate it.
Transaction OAOR:
Class name: REPORTWRITER
Class type:OT
https://me.sap.com/notes/1992004
https://me.sap.com/notes/0003261967
Class name:EHSEXCEL
Class type: OT
https://me.sap.com/notes/2594418
https://me.sap.com/notes/3247649