OneStream

How to Setup the OneStream Excel Add-In and Get Started Using its Features: Part 1

One of the most common questions asked for new OneStream users is “How can I setup and use the OneStream Excel Add-In?” This two-part guide will serve as a resource that OneStream users can utilize to quickly install, log in, and benefit from the handy features within the OneStream Excel Add-In. The OneStream Excel Add-In is an Excel COM add-in that can be used for tasks such as entering data, opening Cube Views, and performing ad hoc analysis.

First, let’s focus on installing the OneStream Excel Add-in and making sure the correct version is installed on the user’s machine. The add-in’s version number must match the OneStream application’s version number because currently there is no backwards compatibility.

There are a few ways to ensure the correct version installed:

  1. Uninstalling the outdated add-in and retrieving the matching version’s installation files from the XF MarketPlace to install and setup.
  2. Using the “Client Updater” in the application tab of OneStream to update the add-in.

Assuming the user does not have the add-in installed, the following section will go into detail on the first point above. If an outdated version is installed on the user’s machine, it can easily be uninstalled by going to “Control Panel” and clicking ”Uninstall A Program”.

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

Uninstalling A Program In Control Panel Copy

From the next window containing a list of all the programs, find “OneStream Excel Add-in” and right-click “Uninstall”.

Right Click Uninstall In Control Panel

With the old version uninstalled, the following instructions will show the steps to install the correct version of the add-in:

  1. Find the current OneStream version in the OneStream Client Application. This can be found by heading to the login page.Application Server Address Copy
  2. Download the correct version of the OneStream Excel Add-in’s installation files.
    1. Access the XF MarketPlace.
    2. Click the computer icon next to “Platform”.Marketplace Home Page Platform
    3. On the next page, click the drop-down list and select the version that matches the version found in the first step. Since the application is currently on version 6.2.1.11728, “Platform Version 6.2.1” would be selected.Marketplace Platform Version And Client Copy
    4. After making sure the correct platform version is selected, click the icon under the “Client” module. A download window will pop up.Marketplace Client
    5. Save the zip file where it can be accessed (for example, on the desktop)
    6. Open the zip file, right-click on the white space within the window and select “Extract All”.Zip File Extract All
    7. Extract the zip file where it can be accessed. Here is the folder that will be produced after extraction.Extracted Folder Copy
  3. Running the Setup file and Installing the add-in
    1. Open the newly extracted folder. The contents of the folder should be the same as the zip file’s content from step two above.
    2. Open the folder “OneStreamExcelAddin”.Extract Folder Contents Copy
    3. Right-click on “Setup.exe” and select “Run as Administrator”.Setup File Run As Administrator Copy
    4. A User Account Control window will pop up asking if you “Want to allow this program to make changes to your device”.
    5. Click “Yes”.
    6. The InstallShield Wizard window will appear.
    7. Walk through the steps of the InstallShield
    8. Accept the User License Agreement.
    9. Enter the user information in the “Customer Information” window. Below is an example of a screenshot of this information.Customer Information Installation Window
    10. Make sure the “Complete” radio button is selected on the “Setup Type” window before moving on. This will ensure all features of the add-in are installed.Complete Setup Type Installation Copy
    11. Click “Install” on the installation window.Clicking Install On Installshield Wizard Copy
    12. After the installation is complete, Click “Finish”.
  4. Make sure the COM add-in is enabled within Excel.
    1. Open Excel
    2. Click “File” on the top left corner of the screen
    3. Click “Options” on the left side of the screenOptions Tab In Excel Copy
    4. Within the Excel Options window, select “Add-ins” on the left sideAdd Ins Button On Options Window In Excel Copy
    5. In the drop-down on bottom of the Add-Ins window, select “COM Add-ins” and click “Go”Com Add Ins And Go Button Copy
    6. Make sure the checkbox next to “OneStreamExcelAddIn” is selected.Excel Add In Enabled And Ok Button Copy
    7. Click “Ok”.

After following these steps the add-in should be correctly installed and fully enabled within Excel.

In the second installment of this guide, we’ll demonstrate how OneStream users can connect to the OneStream Excel Add-In, create a simple quick view, and launch documents from the Context Pane.

About the Author

Phil Kaplanis is a technical consultant with notable experience in consolidation and planning cloud applications. His OneStream background includes dimensional hierarchies, data input, data quality, data visualization, error troubleshooting, financial reporting, and Task Manager. Phil’s results-oriented approach has led to multiple successful finance and accounting projects.

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up