Excel Blocking Macros...on just one file in folder

[Match12]

I have hundreds of files in a folder that all use the same set of macros. The folder has been added to "Trusted Locations" and setting are set to "Enable All Macros".
The Excel gods have decided to block the macros on one file.
I copied the file out of the folder(macros were still block in new location -again a trusted one), stripped the macros, saved, added the macros back in, saved and closed
All macros fired properly when I open the file.
I then saved the file back to the original location. Saved and Closed. When I reopened the file, again the macros were blocked.
I am lost...

 

[jkpieterse]

Does the code contain API calls by any chance? See Attack surface reduction rules reference - Microsoft Defender for Endpoint
and ASR Rule - Block Win32 API Calls from Office Macro | Microsoft Community Hub

 

[Micron]

Do you get the warning near the top of the ribbon that macros are disabled?
Did they ever work when the file was in the source folder?

I copied the file out of the folder(macros were still block in new location -again a trusted one), stripped the macros, saved, added the macros back in, saved and closed
All macros fired properly when I open the file.
I then saved the file back to the original location. Saved and Closed. When I reopened the file, again the macros were blocked.

That suggests to me that
a) the folder is not under TL (but you are probably correct when you say it is) or
b) there's something wrong with the folder. Maybe create a new folder and place the file in it and see if that changes anything.

 

[Candyman8019]

If you go to properties on the file, is there an 'unblock' checkbox? If so, check it and click OK.

 

[Micron]

I thought of that but ruled it out because I don't think all of this would have been possible if that were the case.

stripped the macros, saved, added the macros back in, saved and closed
All macros fired properly when I open the file.

I guess no harm in checking anyway.

 

[Match12]

@Micron - There are a couple hundred files in that folder..all using the same macros...and they all work as designed.
The file in question did not work in its' original locacation..so I copied it out to work with it.

 

[Match12]

@Candyman8019 - that option is not available; I looked!

 

[Candyman8019]

When you copy the file back to it's proper location is the path/filename length too long with this particular file? If it's going to a sharepoint repository, is there any requirement for a security classification property, ie internal, public facing, etc. that may need to be set?

 

[Match12]

Do you get the warning near the top of the ribbon that macros are disabled?
Did they ever work when the file was in the source folder?

That suggests to me that
a) the folder is not under TL (but you are probably correct when you say it is) or
b) there's something wrong with the folder. Maybe create a new folder and place the file in it and see if that changes anything.

If you go to properties on the file, is there an 'unblock' checkbox? If so, check it and click OK.

View attachment 122991

When you copy the file back to it's proper location is the path/filename length too long with this particular file? If it's going to a sharepoint repository, is there any requirement for a security classification property, ie internal, public facing, etc. that may need to be set?

No..the file name is no longer than any other in the folder..total characters in file path is 94

 

[MARK858]

Did you read post 2 about API code? I just can't see a response to it