Situatie
When this error occurs, it simply means that Microsoft Office has disabled the execution of macros by default due to some security reasons. And Excel doesn’t allow to enable the macros.
Solutie
Pasi de urmat
Unblock a File from Properties
- First of all, close the opened Microsoft Excel document
- Next, right-click on that Excel file > go to the properties
- Under the tab “general”, you have to click on a checkbox nearby unblock (see in the below-shown fig.) that is in a security section
- After that, click on the Apply & OK to save all the changes you made
- Then, run macros & then check. In order to do this, open your Excel workbook & click on “View” at the top
- Now, you have to click on the Macros dropdown >> choose the view macros
- Here, click on the run button in order to run macros
- Lastly, check whether the error is fixed or not. If not, move ahead to the next solution.
Add the Trusted Locations to Fix Microsoft Has Blocked Macros from Running Excel
- Initially, open your Microsoft Excel on a PC
- Then, go to File menu
- After this, scroll down & find the ‘Options’, and click on it
- Under the opened window, choose the Trust Center on the left side
- Next, click on the Trust Center Settings option
- There, you have to choose the trusted locations & click to add a new location of your Excel file.
- Now, click on the Browse & choose the location or folder where you want as a trusted location >> click ok to proceed
- Don’t forget to tick on a checkbox beside the “Sub-folders of this location are also trusted”.
- Click OK to save all the changes. Now, you won’t receive the error when you import or download the Excel files in a trusted location/folder
- Finally, close & reopen your Excel file from a trusted folder. Now, it’ll allow you to simply run the macros on any MS Excel file
Uninstall & Reinstall the Microsoft Excel
- Press Win + R keys simultaneously to launch the Run dialog box
- Next, type appwiz.cpl >> hit Enter key. This will ultimately open all the programs & features window of a control panel
- After that, find Microsoft 365 or Microsoft Office & click on it
- Click Uninstall option that you can see at the top. Now, follow the on-screen instructions for completing the process
- Visit the Microsoft official website & log in to your Microsoft account
- Then, from the home page of Microsoft 365, you need to select the button “Install Office”
- Now, you have to choose the Office version that you need to install >> click Install
- After this, accept the license agreement & follow the on-screen instructions
- Once the process gets over, restart the PC and check if the problem is solved.
Leave A Comment?