Configuring Add-In for Excel

Use the MS Excel options window to configure which parts of the Add-In for Excel installation are visible in MS Excel.

Enable or disable the Add-In for Excel tab

You can configure whether the ACL Add-In tab is displayed in the Microsoft Excel Ribbon. The tab is displayed by default. If you choose to hide the tab, all Add-In for Excel functionality is disabled, including data protection.

  1. Click File > Options > Add-Ins.
  2. From the Manage list, select COM Add-ins and click Go.
  3. In the COM Add-ins dialog box, do one of the following and then click OK:
    • To display the ACL Add-In tab, select ACL Add-In.
    • To hide the ACL Add-In tab, clear ACL Add-In.

    Note

    Do not click Remove if the ACL Add-In checkbox is selected. Clicking Remove will permanently remove the Add-In for Excel. If you do mistakenly click Remove, see Repair the Add-In for Excel installation for information on restoring your Add-In for Excel installation.

Show or hide the Analytics Exchange menu

You can configure whether the Analytics Exchange menu is displayed in the Add-In for Excel tab in the Microsoft Excel Ribbon. The menu is displayed by default. If your organization does not have Analytics Exchange available you can hide these AX Server specific options.

  1. Click File > Options > Add-Ins.
  2. From the Manage list, select COM Add-ins and click Go.
  3. In the COM Add-ins dialog box, do one of the following and then click OK:
    • To display the Analytics Exchange menu, select AclAxAddin.
    • To hide theAnalytics Exchange menu, clear AclAxAddin.

    Note

    Do not click Remove if the AclAxAddin checkbox is selected. Clicking Remove will permanently remove the Analytics Exchange component. If you do mistakenly click Remove, see Repair the Add-In for Excel installation for information on restoring your Add-In for Excel installation.