Aug 31 2022 03:04 AM
Aug 31 2022 03:04 AM
I am not sure this forum is correct for me to post the Excel 2016 problem, there is a macro Excel file .xlsm that I have been using it for few years in company, but recently, when I open the file, it show a pink color bar on the top and the message is "Microsoft has blocked macros from running because the source of this file is untrusted.", OK, I searched some solutions from any websites, they all said...please go to Excel > Options >Trust center > trust center settings...Macro settings -> Enable all macro, no luck.
Try to add network drive on "Trusted location" but it doesn't accept network drive.
On "Trusted documents" item, I tried to enable "Allow documents on a network to be trusted" but still no luck.
can someone let me know what is going on on Excel 2016 ? Also, the weird thing is when I copy this macro file to another computer which runs Excel 2019, everything is OK.
My current PC running Win10 Pro, MS Office home and business 2016
Aug 31 2022 01:15 PM - edited Aug 31 2022 01:16 PM
I had the same problem today. I got the message, but wasn't able to add the network share to my trusted locations. When you click on "Learn more" it gives you the instructions how to add a trusted website, but it works similar with network shares.
Click the start button and search for internet properties. In the tab Security, choose the icon for "Local Intranet" and klick "Sites", "Advanced" and add the network share, e.g. \\192.168.0.1\Sharename or the drive letter of a mapped share. That's it, now you can open the document with macros.
Sep 05 2022 04:24 PM
Hello, @liyy23, the workaround on your issue is remapping the network drive to the fileserver name first and then adding that mapped directory to the trusted locations in excel.
\\fileserver\networkdirectory and not \\[192.xxx.xxx.xxx]\networkdirectory
Check this useful thread for more details. Thanks to Uwe Thiess for giving a meaningful solution to your problem, but maybe my answer will be also helpful to the users.
One more suggestion is to consider learning more information about Microsoft 365 backup to recover at any moment after common system glitches.
Sep 10 2022 10:34 AM