Macro getting blocked and raising Security Concern on MS Excel office 365

Vishal Mulchandani 1 Reputation point

In Office 365 MS Excel is blocking Macros for files saved on Network because of recent changes done by Microsoft. Have referred this article but nothing has worked.

If I save file on local disc of computer then all macros are working.

Also, in the above article, it is written that by right clicking file , through properties we can unblock. However, this option is also not visible for the same file.

Kindly advice at earliest.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,364 questions
{count} votes

2 answers

Sort by: Oldest
  1. Ceasar Chen_MSFT 4,356 Reputation points

    Hi, @Vishal Mulchandani
    Welcome to the Q&A forum.
    Microsoft blocked VBA macros by default for Word, Excel, PowerPoint, Visio and Access in Office 365 from April. To enable these macros, you need to save the file to a local hard drive, network drive, or cloud storage service such as OneDrive, and then manually unblock the file.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Vishal Mulchandani 1 Reputation point

    Hello @Ceasar Chen_MSFT

    Thank you for your reply.

    Actually, I have tried the same but there is no option of Unblock when we right click on file.

    Is there any other option to allow macro/unblock the same.?