Microsoft Excel Security Issue Disabling Macros

Microsoft Excel Security Issue Disabling Macros

Overview of Microsoft Security Issue

Earlier in 2022, Microsoft added a security measure to Office applications where it blocks Visual Basic for Applications(VBA) macros by default on any files sent via the internet. You cannot prevent the block from happening but you can unblock the file to enable full functionality

What does this mean for any user receiving a file via email or downloading a file from the internet?

This question is answered in relation to Excel files.

If the Excel file you have received contains macros then these macros will be blocked resulting in loss of some functionality within the workbook.

Disabled File

The image below displays the security warning when you open such a file:


Disabled Macros

The file can be unblocked, however if Excel does not have the correct settings to allow macros to be used then Microsoft will display another warning message such as the image below:


Disabled Editing

Another Microsoft protection feature with files received as mail attachments is that which is related to opening a file directly from the email. Such files are opened in protected view which means you cannot edit them until you click the “Enable Editing” button


How to unblock a file

Follow these steps to unblock any excel file you receive on an email message:

1.     DO NOT OPEN THE FILE DIRECTLY FROM THE EMAIL.

2.     Save the attachment to your local hard drive or a network folder

   

3.     Go to windows File Explorer and locate the file you have just saved.

4.     Right click on the file and select Properties

   

5.     Click the Unblock box
  

6.     Click Apply

7.     Click Ok

8.     Now you can open the file within Excel


How to set Microsoft Excel to always Enable Macro

1.     Open Excel

2.     Select File
  

 

3.     Select Options  (located right at the bottom of the file menu)

                 
  

4.     Select Trust Centre
  

5.     Click the Trust Centre Settings box on the right

6.      Select Macro Settings



7.     On the right click on “Enable VBA macros……..”

8.     Click Ok.


How to prevent files from opening in Protected View

1.     DO NOT OPEN THE FILE DIRECTLY FROM THE EMAIL.

2.      Save the attachment to your local hard drive or a network folder

3.     Open the file from your saved location


Opening files from Sharepoint

1.     The preferred method is to open these files in your local app as opposed to open in browser.

2.     Right Click on the file and select Open

3.     Then select Open in App

 
This method will open your local copy of excel and allow you to have full functionality of any features built into the file.

You will be able to save your changes to the file or save a copy to your local drive.


    • Related Articles

    • Enabling Macro Settings in Microsoft Excel

      Desired Settings To enable many of the Intelligence Reporting reports to run, you need to ensure that all Macro's are fully enabled as they are used extensively throughout all of the reports. Change macro settings in the Trust Center Macro settings ...

    • Setting up an Excel ODBC (32bit) System DSN

      Issue You would like to connect to Excel files to use as data in your Intelligence Reports Resolution You need to configure a 32bit System DSN on all workstations. Instructions as follows: Set up a System Data Source Name (DSN) using the Microsoft ...

    • Reducing the size of Microsoft Excel file automatically

      Here is a quick tip on reducing the size of Microsoft Excel file quickly and easily. You may need to reduce it for any number of reasons, and this is a quick way to get that done. Launch Microsoft Excel or the Microsoft Workbook in question Go to ...

    • Saving your entire report to PDF

      Save your entire report to PDF using macros and Sage Intelligence Being able to save your reports to PDF provides a convenient way to view and share them. Sage Intelligence provides two common ways that you can do this. These include; distributing a ...

    • Unable to set the Interactive Property of the Application Class

      Issue When running a report, you are running into an error about setting the Interactive Property for the Application Class. Symptoms When running a Report out the following error is received: Unable to set the Interactive property of the Application ...