Forum Discussion

leonardosr's avatar
leonardosr
Copper Contributor
Jun 21, 2022

Macros not working in local network

After the last Excel update, all the macro present of files that are saved on a local network have been disabled. How can I enable them?

I am 100% sure about the origin of the files, so I must enable the macros to properly use the files.

I wait for your kind feedbacks.

excel
  • Dmayso's avatar
    Dmayso
    Copper Contributor
    Jun 22, 2022

    leonardosr 

     

    I'm having the same (similar?) issue.

    I use a lot of macros throughout a lot of Excel files.  Now, I can't seem to enable them at all.  Not through the Trust Center anyway.  I can't seem to enable "trusted location on my network" - even though that box is clearly checked.  I cannot seem to get any message other than "SECURITY RISK Microsoft has blocked macros from running because the source of this file is untrusted."  I WROTE THE FILE!!

     

    Arrgghh... so frustrating.  I can't get this to work.

     

Resources