I am getting macro error while opening excel file. Please suggest how to resolve

Question

I am getting Macro error frequently while opening any excel file. Please assist on how to resolve the same.

Answer 1

Hi Arpita,

Thanks for contacting us and sorry for the inconveniences,

Here are some steps you can try to fix this issue:

• Check your macro settings and make sure they are enabled or set to the appropriate level. You can do this by going to File > Options > Trust Center > Trust Center Settings > Macro Settings in Excel. You can choose to enable all macros, disable all macros, disable all macros with notification, or disable all macros except digitally signed macros.
• Check your network connection and make sure it is stable and working. You can try to restart your router, modem, or computer, or use a different network if possible.
• Check your security software and make sure it is not blocking or interfering with Excel or your macros. You can try to temporarily disable your antivirus, firewall, or VPN software, or add Excel and your macros to the list of trusted or allowed programs. You can also use the Microsoft Support and Recovery Assistant tool to scan and fix any issues related to security software.
• Check your Excel files and make sure they are not corrupted or damaged. You can try to repair your Excel files using the Open and Repair feature or the Excel Repair tool. You can also try to create a new Excel file and copy your macros to it.

Let me know if this helps or if you need further assistance.

Regards, Sola

“Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below. “

Kindly note that this is a user to user forum, we are users helping other users, we aren't Microsoft employee neither are we Microsoft agents.

Answer 2

Hi, I am still getting following error every time I open my excel file.

Answer 3

Remove the Excel AddIn, please read this article:
https://support.microsoft.com/en-au/office/add-or-remove-add-ins-in-excel-0af570c4-5cf3-4fa9-9b88-403625a0b460

Andreas.

Answer 4

Hi again,

I'm sorry I wasn't able to help, unfortunately, I do not have any more troubleshooting to offer, there are knowledgeable experts on the platform and I hope someone else will take a look at your issue.

Thanks, Sola