How to Enable Macros: PI Builder Updated 1/2013 The following recommendations are derived from common errors when working in the Marketing Data Tool (MDT) application. This document will be updated on a frequent basis as Lowe’s makes improvements to its processes and efficiencies. If you need additional information on MDT, review the documents How to Submit New Items and How to Submit Existing Items for greater detail. In order to use PI Builder, you must have macros enabled in Excel on your computer. Follow the guidelines below to enable macros based on your platform: Enable Macros in Excel (2007 Platform)   Open a blank Excel document Select the Microsoft Office logo button from the top-left corner of Excel  Select the Excel Options button in the bottom right-hand corner of the menu http://sharepoint/merch/merch1/pitrncomm/Team%20Documents/How%20to%20Enable%20Macros.docx Lowe's Companies, Inc. | Confidential Created by LMB| Updated by LSM 1.1.2013 1   Select the Trust Center tab Select Trust Center Settings      Select the Macro Settings tab Select the radio button to Enable all macros Select the box to Trust access to the VBA project object model Click OK to save settings Close out of all Excel files and re-open Excel for changes to take effect http://sharepoint/merch/merch1/pitrncomm/Team%20Documents/How%20to%20Enable%20Macros.docx Lowe's Companies, Inc. | Confidential Created by LMB| Updated by LSM 1.1.2013 2      Select the External Content tab Select the radio button to Enable all Data Connections (not recommended) Select the radio button to Enable automatic update for all Workbook links (not recommended) Click OK to save settings Close out of all Excel files and re-open Excel for changes to take effect http://sharepoint/merch/merch1/pitrncomm/Team%20Documents/How%20to%20Enable%20Macros.docx Lowe's Companies, Inc. | Confidential Created by LMB| Updated by LSM 1.1.2013 3 Enable Macros in Excel (2010 Platform)    Open a blank Excel document Select File from the top-left corner of Excel Select Options    Select the Trust Center tab Select Trust Center Settings Select the Protected View  Deselect the Enable Data Execution Prevention mode http://sharepoint/merch/merch1/pitrncomm/Team%20Documents/How%20to%20Enable%20Macros.docx Lowe's Companies, Inc. | Confidential Created by LMB| Updated by LSM 1.1.2013 4  Select Macro Settings  Select Enable all macros (not recommended; potentially dangerous code can run)   Select Trust access to the VBA project object model Select External Content  Select Enable all Data Connections (not recommended)  Select Enable automatic update for all Workbook Links (not recommended)   Click OK to save settings Close out of all Excel files and re-open Excel for changes to take effect Help If you need additional assistance, please contact Product Information via the Product Information Support Portal. http://sharepoint/merch/merch1/pitrncomm/Team%20Documents/How%20to%20Enable%20Macros.docx Lowe's Companies, Inc. | Confidential Created by LMB| Updated by LSM 1.1.2013 5