Show TOC

To configure the load behavior of the Analysis Add-InLocate this document in the navigation structure

Context

With the load behavior, you can enable users to access Analysis in any Microsoft Excel and Microsoft PowerPoint file. You have to set the LoadBehavior parameter to the required value in the registry of the client PCs.

If the Add-In is enabled, it is always active when you start Microsoft Excel or PowerPoint. Before users can access Analysis in any Microsoft Excel or Microsoft PowerPoint file, ensure that Analysis has been started once locally via the launcher in the Windows directory or by choosing the desktop icons. You can also configure all client PCs automatically. In order to distribute the user specific settings automatically, you can define a Group Policy.

If it is disabled, it is active only after starting it with the Add-In Launcher in the Start menu, with he desktop shortcut, or following manual activation in the COM Add-In dialog.

Procedure

  1. To open the registry editor, select Start of the navigation path Start Next navigation step Run End of the navigation path and enter regedit.
  2. Navigate to the folder: HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\SapExcelAddIn and select the LoadBehavior parameter.
    Note After installation, the default value is 3. This means that the Analysis Add-In is enabled.
  3. To enable the Analysis Add-In, set the parameter accordingly:
    Option Description
    0 The Add-In is disabled. Users can enable the Add-In temporarily by activating the Add-In in the COM Add-In dialog box.
    1 The Add-In is enabled. This temporary activation means that the Add-In is disabled again when Microsoft Excel is closed.
    2 The Add-In is disabled. Users can enable it in the COM Add-In dialog box. This sets the value to 3.
    3 The Add-In is enabled. If required, users can disable it in the COM Add-In dialog box. This sets the value to 2.
    For more information on enabling and disabling the Add-In in Microsoft Excel and Microsoft PowerPoint, see the User Guide: Analysis, edition for Microsoft Office at http://help.sap.com.

Results

Analysis is now ready for use in any Microsoft Excel file and in any Microsoft PowerPoint file.