Installing Spreadsheet Add-in

  To install Spreadsheet Add-in:

  1. Ensure that Microsoft Excel is installed with the Visual Basic Option.

  2. Download the Spreadsheet Add-in ZIP file from the Oracle Software Delivery Cloud, unzip the file to a temporary location, and launch Spreadsheet Add-in.exe.

If you are installing Spreadsheet Add-in using Remote Desktop, install using an admin console session. (Launch Remote Desktop using mstsc /admin or mstsc /console).

If you are using Spreadsheet Add-in as a Power User instead of as an Administrator, you must manually set ESSBASEPATH.

If the EPM_ORACLE_HOME environment variable is defined, Spreadsheet Add-in is installed in EPM_ORACLE_HOME/products/Essbase/EssbaseClient by default. If the EPM_ORACLE_HOME environment variable is not defined, Spreadsheet Add-in is installed in EPM_ORACLE_HOME/products/ExcelAddin by default.

The Spreadsheet Add-in installer creates a start menu item: Oracle, Essbase, Essbase Client.

  To run silent installations for Spreadsheet Add-in:

  1. Open a command line prompt.

  2. Navigate to the directory of the Spreadsheet Add-in installer.

  3. Run the following command:

    Spreadsheet Add-in.exe" /S /v"/qn INSTALLDIR=targetPath FOR_CURRENT_USER=user /l*v log"

    where:

    • targetPath — the installation directory. The default value is c:/Oracle/Middleware/EPMSystem11R1. If the EPM_ORACLE_HOME environment variable is defined, this value is ignored.

    • user — specify 1 to install Spreadsheet Add-in for all users or 2 to install Spreadsheet Add-in for the current user only. The default value is 1.

    • log — the path for log files.

    For example:

    Spreadsheet Add-in.exe" /S /v"/qn INSTALLDIR=C:\Oracle\ FOR_CURRENT_USER=1
    /l*v C:\ESS_install.log"