Install-Configure: Microsoft Excel

Different Excel version has slightly different UI and package needed for the configuration.

The purpose is to set suitable Macro Security level, enable Trust Access to VBA Project, and install Office Primary Interop Assemblies (PIA).


Configure Excel 2003

  • From Excel menu, click Tools then Options to open Options window,

    On the Security tab, click Macro Security… button,

    On the Security Level tab, choose "Medium" or "Low". (screen shown as below)

    Note that "Medium" level still causes a Security Warning message to pop up when you open spreadsheet, then please click Enable Macros button. "Low (not recommended)" is less secure thus no Security Warning message any more.

    XL_2003_macro_security_low.gif


    On the Trusted Publishers tab, check option "Trust Access to Visual Basic Project". (screen shown as below)

    XL_2003_trust_publisher.png
  • Download Office 2003 Primary Interop Assemblies (PIA) and follow instructions there to install it.

    2003 Microsoft Office System Update: Redistributable Primary Interop Assemblies (PIA)
    http://www.microsoft.com/en-us/download/details.aspx?id=20923

Configure Excel 2007

  • From File tab, click Options to open Excel Options dialog box.

    Click Trust Center on left pane, click Trust Center Settings… button to open Trust Center dialog box.

    Click Trusted Locations on left pane, add the directory where ATSXL resides as trusted location.

    (Click the Add New Location button, Click Browse, select the folder that you want to trust, then click OK.)

    The screen shows that a directory D:\DEV\ATSXL\ is being added as trusted location.
    (You should choose D:\myATSXL\, if you are following steps from one of the QuickStart Guides.)

    XL_2007_setup_trusted_location.JPG


    The screen shows that a directory D:\DEV\ATSXL\ is added as trusted location:
    (You should choose D:\myATSXL\, if you are following steps from one of the QuickStart Guides.)

    XL_2007_trusted_location.JPG


    Click Macro Settings on left pane, check option "Trust access to VBA project object model".
    Note that you can choose "Disable all macros with notifications" for better Macro Security, if you set up trusted location properly for ATSXL.

    XL_2007_enable_macro_and_access_to_VBA.JPG

Configure Excel 2010

  • The following steps are similar as in Excel 2007, please refer to screen shots for Excel 2007 if needed.

    From File tab, click Options to open Excel Options dialog box.

    Click Trust Center on left pane, click Trust Center Settings… button to open Trust Center dialog box.

    Click Trusted Locations on left pane, add the directory where ATSXL resides as trusted location.

    (Click the Add New Location button, Click Browse, select the folder that you want to trust, then click OK.)

    Click Macro Settings on left pane, check option "Trust access to VBA project object model".
    Note that you can choose "Disable all macros with notifications" for better Macro Security, if you set up trusted location properly for ATSXL.

Upon here, you have configured Microsoft Excel successfully.

You can return to any of the following link:


2010 - 2015 WWW.ATSXL.COM COPYRIGHT NOTICE