Forum Discussion
issue with Macros untrusted file
Hello, im having an issue with just specific excel file that contains a macro, when that files get duplicated or change name, the macro stops working and there is no way around to enable macros or even by adding the file location in trusted files we can make it work.
If we see the first image, there no option to enable macros it stays disabled
- Go to File | Info | Properties | Advanced Properties - clear the Author. Save the workbook, close it and re-open to test.
Patrick2788 thanks for the suggestion. i did actually work for me but only once. After another restart the file got the same message.
I was able to figure it out, under Options > Trust Center > Trust Center Settings > Trusted Locations enter the location on the OneDrive File using the address as https://d.docs.live.net/.../ instead as the regular windows explorer address. that seems to finally make the trick for me.
Hope this helps others with this issue, spent many hours with support and by myself trying to figure it out.
thanks
- Indeed. There are a few solutions to the current security issues:
1. Clear meta data
2. your trusted location solution
3. Clear trusted document cache
