Cannot enable macro in Office 365 in an Excel file I have used for years. Says I do not have anti-virus. What can I do?

Question

I cannot enable macros in Excel in Office 365 for a file I have used for years and have been able to use on this computer until the past week. The message says I do not have anti-virus to scan the file and it does not give me an option to enable it. I have been all through the trusted center and selected multiple settings. I have Trend Micro Internet Security for my anti-virus. What can I do? 

Answer 1

Hi

First, you do NOT want to enable all macros.

Instead, disable all macros with notification. (That does not really mean all macros.)

Second, you do NOT want to enable access to the vba project object model unless you have some other reason to do so.

You should have Windows defender enabled.

Error messages in Excel like this may or may not have meaning.

You should set your Trust Center settings to have Trusted Locations and put the files you want to authorize macros on in one of those locations.

First, try opening in Safe mode.

https://support.office.com/article/Open-Office-...

Safe mode is a diagnostic step, not a way to run Excel.

If that helps, write back and we'll try to get to the bottom of the cause.

If opening in Safe mode doesn't help, I would recommend a repair.

https://support.office.com/article/Repair-an-Of...

Try the quick method first. It is less comprehensive but much quicker than the online repair.

This forum is a user-to-user support forum. I am a fellow user.

I hope this information helps.

Please let me know if you have any more questions or require further help.

You can ask for more help by replying to this post (Reply button below).

Regards