Macro not working with office 365 when downloading report from SAP

Sandeep272003 

When you encounter the "Microsoft Excel Security Notice" stating that macros have been blocked due to the file being untrusted, it means that Excel's security settings are preventing the execution of macros from potentially unsafe sources. To enable the macros and resolve the issue, you have a few options:

1. Enable macros for the current file: If you trust the source of the file and want to enable macros for it, you can follow these steps:
• Close the security notice dialog.
• Go to the "File" tab and click on "Options."
• In the Excel Options dialog, select "Trust Center" from the left menu.
• Click on the "Trust Center Settings" button.
• In the Trust Center dialog, select "Macro Settings" from the left menu.
• Choose the option "Enable all macros" or "Enable all macros with notification" if you want to be alerted when a macro runs.
• Click "OK" to apply the changes and close the dialogs.
• Reopen the file, and the macros should now be enabled.
2. Move the file to a trusted location: By default, Excel only allows macros to run from trusted locations. You can move the file to a trusted location to enable macros without encountering the security notice. The trusted locations include the default trusted folders such as the "Documents" folder or a custom trusted location you can specify.
• Go to the "File" tab and click on "Options."
• In the Excel Options dialog, select "Trust Center" from the left menu.
• Click on the "Trust Center Settings" button.
• In the Trust Center dialog, select "Trusted Locations" from the left menu.
• Click on "Add new location" to specify a new trusted location, or select an existing trusted location.
• Browse and select the folder where the file is located, or create a new folder.
• Click "OK" to apply the changes and close the dialogs.
• Move the file to the trusted location, and the macros should now be enabled.

Note: Be cautious when enabling macros from untrusted sources, as they can potentially contain malicious code. Ensure that you trust the file and its source before enabling macros.

These steps should help you enable macros for the specific file or allow macros to run from trusted locations, depending on your preference and the level of security you require.