I unblocked the macros in a spreadsheet and still I cannot do some calculations

Note: This Microsoft Q&A forum is moderated in Greek. However, since you speak a language other than Hellenic, I understand that it may not be your native language. To better assist you, I will respond in your language. Please be aware that the information you provide will be automatically translated. While we strive for accuracy, the translation may not fully reflect the original context.

Hello Stylianos Karastergios,

Thank you for reaching out in Microsoft Q&A forum

I understand how confusing it can be when you have already unblocked a macro enabled Excel file from a trusted source, but the calculations still do not run as expected.

In this situation, unblocking the file at the Windows level is only one part of the process. Even after that, Excel may still prevent calculations if the file is not fully trusted or if the workbook is opened in a restricted state. Here are the key things to check:

1. Make sure the file is opened as a macro enabled workbook. Confirm the file extension is .xlsm and not .xlsx, because macros and macro driven calculations will not run in a standard .xlsx file.
2. Verify that macros are actually enabled inside Excel, not just unblocked at the file level. Open Excel, go to File, Options, Trust Center, Trust Center Settings, Macro Settings, and make sure “Disable VBA macros with notification” is selected. Then reopen the file and click Enable Content on the security warning bar if it appears.
3. Another common reason calculations still do not work is that the file is not in a Trusted Location. Even trusted downloads can be restricted unless the folder itself is trusted. You can add the folder where the spreadsheet is stored by going to File, Options, Trust Center, Trust Center Settings, Trusted Locations, and adding the folder path.
4. Also check Excel calculation mode. If the workbook is set to Manual calculation, formulas and macro driven calculations will not update automatically. In Excel, go to the Formulas tab and confirm Calculation Options is set to Automatic.
5. If the file is opened directly from OneDrive, SharePoint, or a network location, try saving a local copy to your computer and opening it from there.

Hope this helps

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

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.