Forum Discussion
Problem Enable Macros on Excel
Natanael90 we face the same issue, temporary solution will just need to open any excel file with data inside and leave it (dont close the excel) than continue generate report from SAP and it will work.
from there you able to view the cert, you can choose to import and export than place in trusted publisher in excel later, so you can run the report without any excel open.
Since we already tried your method, opening the excel doesn't give amy response to view certificate and import/export.
Show Signature Details link
View Certificate button
Install Certificate button
Choose the certificate place in current user under trusted publishers than ok
than you are good to go without any excel open also can generate report from SAP now. (please make sure you have excel open with data, only you have the enable button visible and the show certificate link)
Hi thanks for your response again,
How to enable the "Show Signature Detail" ? Seems our SAP doesn't produce any certificate while generating the report
This is what i produce when tried to generate the report from capable computer.
There is only Enable Button Macros without Signature details to export the certificate and put the certificate on problem computer.
 
- If you can open Excel with macors. Then
goto View-->Macros popup shows macro list then click Edit
VBA editor will open then goto menu Tools--> Digital Signature
Certificate name: SAP AG click Detail button.
Details TAB click Copy to File
Then Import .cer file to Internet option --> Content TAB --> Publishers button --> Import
Check again in Excel - Option - Trusted Center - Trusted Publishers
- I'm having the same problem but also with no "Signature Details" button. Any solution to this? SAP is a pretty huge necessity to a lot of organizations
hi wonderbeef1905 I have the certification you need. Also i can show you how to get it. Contact me email address removed for privacy reasons
