Macros disabled in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2163057%22%20slang%3D%22en-US%22%3EMacros%20disabled%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2163057%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22George25_0-1614187394062.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F257442i914BE83AA5CBAD56%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22George25_0-1614187394062.png%22%20alt%3D%22George25_0-1614187394062.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWe%20have%20installed%20office%20365%20on%20a%20new%20pc%20but%20macro%20enabled%20workbooks%20have%20been%20disenabled%20and%20the%20button%26nbsp%3B%20above%20doesn't%20allow%20us%20to%20enable%20macros%20on%20this%20pc.%20We%20don't%20have%20this%20issue%20on%20any%20other%20pc.%20We%20have%20tried%20uninstalling%20and%20reinstalling%20office%20365%2C%20also%20we%20have%20wiped%20the%20hard%20drive%20by%20doing%20a%20factory%20reset%20but%20nothing%20has%20resolved%20the%20problem%20and%20'technical%20support'%20(case%20number%3A%26nbsp%3B1018125555)%20have%20not%20been%20able%20to%20assist.%20We%20understand%20this%20is%20a%20known%20issue%3F%20Glad%20of%20help%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

George25_0-1614187394062.png

We have installed office 365 on a new pc but macro enabled workbooks have been disenabled and the button  above doesn't allow us to enable macros on this pc. We don't have this issue on any other pc. We have tried uninstalling and reinstalling office 365, also we have wiped the hard drive by doing a factory reset but nothing has resolved the problem and 'technical support' (case number: 1018125555) have not been able to assist. We understand this is a known issue? Glad of help please?

1 Reply

Hi @George25 , good afternoon. 

 

I don't think this is the right site to post this kind of issue, but anyway, I'll try to help you. 

 

You should ask you if:

  • The computer is domain joined and you are applying some GPOs related with Office configuration.
  • If the Excel file you are trying to open is secure
  • if the Excel file you are trying to open is within a trusted location.
  • if the Excel file you are trying to open is in a network path trusted location

 

You can view these settings in the Trust Center. So in Excel, Select File > Options, then select Trust Center in the left-hand list and click “Trust Center Settings…” From here you can check:

 

  • In the Trust Center dialog, select “Macro Settings
  • In the Trust Center dialog, select “Trusted Documents
  • In the Trust Center dialog, select “Trusted Locations

 

I hope this can help you. Please, use the right group like Office / Excel to post any issue related with Office Apps. 

 

Good luck!

  •