Macros of deployment spreadsheet are disabled by administrator

Last Updated : Feb 25, 2021 |
Prolog information
Metadata
Keywords:

Condition

Unable to enable the Macros of the deployment spreadsheet, as it displays the following error:
Macros in this document have been disabled by your enterprise administrator for security reasons

Cause

Files are not in a trusted location of your machine.

Solution

  1. Place your files, including the deployment spreadsheet, in a trusted location.
    1. Go to FileOptionsTrust CenterTrust Center Settings.
    2. On the left navigation pane, click Trust Locations.
    3. If a trusted location exists, select the location where you want to move the files.
    4. Select the deployment spreadsheet from the current location and click Ok.
    5. If there is no trusted location, first create one and then move the files.