安装配置: 微软 Excel

以下配置过程中,不同版本的微软 Excel 有稍微不同的界面,并需要下载不同的安装包。

这里的主要目的是设置宏安全级别,激活VBA Project的可信任访问,安装 Office 互操作组件(PIA)。


配置 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

配置 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

配置 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.

至此,用户已经成功配置地了微软 Excel。

用户可以返回到下面的链接:


2010 - 2015 WWW.ATSXL.COM COPYRIGHT NOTICE