Blocked Content Message

%3CLINGO-SUB%20id%3D%22lingo-sub-1353899%22%20slang%3D%22en-US%22%3EBlocked%20Content%20Message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1353899%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20attempting%20to%20work%20on%20an%20Excel%20spread%20sheet%20that%20is%20located%20in%20Dropbox.%20I%20am%20receiving%20a%20message%20%22Blocked%20Content%20Macros%20in%20this%20document%20have%20been%20disabled%20to%20help%20keep%20you%20safe.%22%20It%20is%20a%20trusted%20document.%20How%20do%20I%20unblock%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1353899%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1354907%22%20slang%3D%22en-US%22%3ERe%3A%20Blocked%20Content%20Message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1354907%22%20slang%3D%22en-US%22%3E%3CP%3EHI%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F644779%22%20target%3D%22_blank%22%3E%40Paul_Green%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eclick%20on%20enable%20macro%2C%20if%20you%20don't%20find%20the%20enable%20macro%20then%20follow%20the%20steps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EFile%20%26gt%3B%20Option%20%26gt%3B%20Trust%20Center%20%26gt%3B%26nbsp%3BTrust%20Center%20Settings%20%26gt%3B%20Macro%20Settings%20%26gt%3B%20Disable%20Macro%20With%20Notification%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22lia-message-body%20lia-component-message-view-widget-body%20lia-component-body-signature-highlight-escalation%20lia-component-message-view-widget-body-signature-highlight-escalation%22%3E%3CDIV%20class%3D%22lia-message-body-content%22%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2019293%22%20slang%3D%22en-US%22%3ERe%3A%20Blocked%20Content%20Message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019293%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20a%20similar%20problem.%26nbsp%3B%20We%20have%20an%20Excel%20file%20in%20a%20Dropbox%20folder.%26nbsp%3B%20I%20am%20able%20to%20open%20it%20and%20run%20the%20macros.%26nbsp%3B%20However%2C%20another%20person%2C%20opening%20the%20same%20file%20from%20their%20computer%2C%20receives%20the%20message%20that%20the%20macros%20are%20blocked%20to%20keep%20you%20safe.%26nbsp%3B%20There%20is%20no%20button%20to%20allow%20the%20macros%20to%20run.%26nbsp%3B%20In%20the%20Trust%20center%20settings%2C%20we%20both%20have%20block%20but%20notify%20selected.%26nbsp%3B%20However%2C%20because%20the%20other%20person%20couldn't%20get%20the%20macros%20to%20run%20on%20her%20computer%2C%20she%20had%20setting%20at%20run%20all%20macros.%26nbsp%3B%20Still%2C%20the%20message%20comes%20up%20when%20she%20opens%20the%20file%20and%20there%20is%20no%20way%20to%20run%20the%20macros.%26nbsp%3B%20This%20is%20Office%20365.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2019294%22%20slang%3D%22en-US%22%3ERe%3A%20Blocked%20Content%20Message%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2019294%22%20slang%3D%22en-US%22%3ETo%20clarify%2C%20earlier%20she%20had%20it%20set%20to%20run%20all%20macros.%20Now%2C%20it's%20set%20to%20block%20but%20notify%2C%20like%20mine.%3C%2FLINGO-BODY%3E
Occasional Visitor

I am attempting to work on an Excel spread sheet that is located in Dropbox. I am receiving a message "Blocked Content Macros in this document have been disabled to help keep you safe." It is a trusted document. How do I unblock it?

 

3 Replies

HI @Paul_Green 

 

click on enable macro, if you don't find the enable macro then follow the steps

 

File > Option > Trust Center > Trust Center Settings > Macro Settings > Disable Macro With Notification

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more.

@Faraz Shaikh 

 

I am having a similar problem.  We have an Excel file in a Dropbox folder.  I am able to open it and run the macros.  However, another person, opening the same file from their computer, receives the message that the macros are blocked to keep you safe.  There is no button to allow the macros to run.  In the Trust center settings, we both have block but notify selected.  However, because the other person couldn't get the macros to run on her computer, she had setting at run all macros.  Still, the message comes up when she opens the file and there is no way to run the macros.  This is Office 365.

To clarify, earlier she had it set to run all macros. Now, it's set to block but notify, like mine.