Microsoft has blocked marcros from running because the source of this file is untrusted (MS office 365 , MS Access)

Question

Microsoft has blocked marcros from running because the source of this file is untrusted (MS office 365 , MS Access)

ขอวิธีแก้ไขด้วยครับ

Answer 1

Hello Phibul C,

Hope you are doing great and well today.

My name is Sarah, I'd be happy to assist you today.

The solution is to re-map the network drive to the fileserver name first and then adding that mapped directory to the trusted locations in excel.

Mapped Location:

\fileserver\networkdirectory and not \[192.xxx.xxx.xxx]\networkdirectory

You may also try to follow the second option if the first instruction doesn't help.

A. Close the workbook.

1. Right-click on the workbook. 2. Select Properties. 3. Under the General tab, make sure to check the Unblock box in Security. 4. Hit the Apply button.

B. Now open the workbook.

1. You will see the error message has now disappeared. 2. Click on View on the top menu bar. 3. At the extreme right on the top menu bar, click on Macros. 4. In the new window that shows, hit the Run button. You will see the macros running without any issues.

Also, note that any files downloaded to the trusted location will not be blocked by default. To view which locations are trusted, you can follow the steps below. You can now download files from the internet to run macros on Excel without any issues.

If you have any concern or clarification. Please comment below for more information.

Best regards,

Sarah