Home

I can't open a Macro enable excel and word file

%3CLINGO-SUB%20id%3D%22lingo-sub-1117615%22%20slang%3D%22en-US%22%3EI%20can't%20open%20a%20Macro%20enable%20excel%20and%20word%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1117615%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20help%20me%20fix%20this%20problem.%3C%2FP%3E%3CP%3EI%20can't%20open%20any%20excel%20and%20word%20file%20that%20has%20macro%20features%20in%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPlease%20see%20the%20picture%20for%20the%20complete%20error%20message.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20525px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F166111iDBF3FA655187ED47%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22error.JPG%22%20title%3D%22error.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F166110i00C677A705CD1CCF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Excel%20Makro.JPG%22%20title%3D%22Excel%20Makro.JPG%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1117615%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1119578%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20open%20a%20Macro%20enable%20excel%20and%20word%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1119578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F525066%22%20target%3D%22_blank%22%3E%40Roxanne26%3C%2FA%3E%26nbsp%3B%26nbsp%3BIs%20it%20just%20these%20two%20files%20or%20are%20you%20not%20allowed%20to%20open%20any%20files%20that%20contain%20macros%3F%3C%2FP%3E%3CP%3ETest%20with%20some%20other%20files%20as%20well%20which%20also%20contain%20macro%20and%20if%20it%20does%20not%20work%20then%20it%20is%20likely%20that%20someone%20has%20done%20some%20admin%20has%20made%20some%20setting%20that%20restricts%20its%20use.%20You%20can%20read%20more%20about%20the%20topic%20here.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FEnable-or-disable-macros-in-Office-files-12B036FD-D140-4E74-B45E-16FED1A7E5C6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FEnable-or-disable-macros-in-Office-files-12B036FD-D140-4E74-B45E-16FED1A7E5C6%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1165356%22%20slang%3D%22en-US%22%3ERe%3A%20I%20can't%20open%20a%20Macro%20enable%20excel%20and%20word%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1165356%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F525066%22%20target%3D%22_blank%22%3E%40Roxanne26%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EHave%20you%20recently%20applied%20the%20new%20o365%20user%20security%20baselines%3F%20One%20of%20the%20changes%20from%20the%202016%20baselines%20to%20this%20one%2C%20was%20the%20addition%20of%20this%20policy%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUser%20Config%20%26gt%3B%20Admin%20Templates%20%26gt%3B%20Excel%202016%20%26gt%3B%20Excel%20Options%20%26gt%3B%20Security%3CBR%20%2F%3EForce%20File%20extension%20to%20match%20file%20type%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20is%20enabled%20by%20default%20through%20the%20baseline%2C%20this%20was%20a%20gotcha%20for%20us.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20file%20may%20also%20be%20incorrectly%20labeled%20as%20%22from%20the%20internet%22%2C%20and%20even%20if%20you%20have%20macros%20enabled%2C%20this%20GPO%20will%20override%20that%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUser%20Config%20%26gt%3B%20Admin%20Templates%20%26gt%3B%20Excel%202016%20%26gt%3B%20Excel%20Options%20%26gt%3B%20Security%20%26gt%3B%20Trust%20Center%20%26gt%3B%3C%2FP%3E%3CP%3EBlock%20Macros%20from%20running%20in%20Office%20files%20from%20the%20Internet%3CBR%20%2F%3E%3CBR%20%2F%3ELast%20but%20not%20least%2C%20there's%20the%20AMSI%20GPO%2C%20where%20office%20will%20leverage%20defender%20to%20scan%20macros%20and%20block%20them.%3CBR%20%2F%3E%3CBR%20%2F%3E%22%3CSPAN%3EThis%20behavior%20can%20be%20controlled%20by%20Group%20Policy.%20In%20the%20Group%20Policy%20Editor%20go%20to%20the%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EMicrosoft%20Office%202016%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Btemplate%20and%20under%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ESecurity%20Settings%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Byou%20should%20find%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EScan%20VBA%20macros%20at%20runtime%3C%2FSTRONG%3E%3CSPAN%3E.%26nbsp%3B%20%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fmalicious-macros-were-found-9e461c61-69d1-4ea9-a386-9ad0deaccfdd%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fmalicious-macros-were-found-9e461c61-69d1-4ea9-a386-9ad0deaccfdd%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ELet%20me%20know%20if%20any%20of%20those%20steps%20helped!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Roxanne26
Occasional Visitor

Please help me fix this problem.

I can't open any excel and word file that has macro features in it.

 

 

Please see the picture for the complete error message.error.JPGExcel Makro.JPG 

 

 

2 Replies
Highlighted

@Roxanne26  Is it just these two files or are you not allowed to open any files that contain macros?

Test with some other files as well which also contain macro and if it does not work then it is likely that someone has done some admin has made some setting that restricts its use. You can read more about the topic here. https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-files-12B036FD-D140-4E74...

Highlighted

@Roxanne26 

Have you recently applied the new o365 user security baselines? One of the changes from the 2016 baselines to this one, was the addition of this policy:

 

User Config > Admin Templates > Excel 2016 > Excel Options > Security
Force File extension to match file type

This is enabled by default through the baseline, this was a gotcha for us. 

 

The file may also be incorrectly labeled as "from the internet", and even if you have macros enabled, this GPO will override that:

 

User Config > Admin Templates > Excel 2016 > Excel Options > Security > Trust Center >

Block Macros from running in Office files from the Internet

Last but not least, there's the AMSI GPO, where office will leverage defender to scan macros and block them.

"This behavior can be controlled by Group Policy. In the Group Policy Editor go to the Microsoft Office 2016 template and under Security Settings you should find Scan VBA macros at runtime.  "

https://support.office.com/en-us/article/malicious-macros-were-found-9e461c61-69d1-4ea9-a386-9ad0dea...

 

Let me know if any of those steps helped!

Related Conversations
Generate Invoice Pricing - Multiple Criteria
TarrahLA in Excel on
0 Replies
Convert text in a cell to number
kaibisnes in Excel on
1 Replies
Userform - Submit button not working
Mr_Buttons in Excel on
2 Replies
IFS with wildcards
itchyfinger in Excel on
3 Replies
Calculating Total hours worked
ChristianMercado in Excel on
5 Replies