Written by Because macro’s can cause a lot of harm when used wrong, they are by default blocked in several ways in Office 2010. When you are using Excel files from a network location, such as a document managing system or network share, macro’s might not work. A solution is to add the network location to your trusted locations. There are two ways to configure this: manually in your Office application or by policy.
Manually