BusinessObjects: Installing BusinessObjectshelpers Add-In

Overview

The BusinessObjects delimiter marcro for Excel is used to paste a list of values, or create grouped values, in BusinessObjects. The following instructions explain how to install and remove the BusinessObjectshelpers Add-In.

If you have previously installed the BusinessObjectshelpers.xlam Add-In file but are experiencing a Digital Certificate Expired error when trying to use the Macro, you need to first remove the Add-In and then reinstall it.

Note: These instructions reference the Excel Options menu. Depending on your Excel version, the Options menu is located in one of the following ways:

  • Microsoft Office 360: Start Excel, or if a spreadsheet is already open click File. Options is located at the bottom of the left-hand panel.
  • Excel 2016: Start Excel and click Open Other Workbooks, or if a spreadsheet is already open click File. Options is at the bottom of the left-hand panel.

Step-by-Step Process

Install BusinessObjectshelpers Add-In

  1. Download the BusinessObjectshelpers.xlam file from Dropbox.
    • Note where the file is saved on your computer; you will need to navigate to it later in this process.
  2. In Excel, click Options.
  3. Click Add-Ins.

    4. Screenshot of the Excel Options window showing the Add-Ins option in the left-hand menu, the Manage Add-Ins drop-down list and the Go button.

  4. Click Go.
  5. Click Browse, then navigate to and select the BusinessObjectshelpers.xlam file downloaded in step 1.

    6. Screenshot of the Add-Ins window showing the Browse button and the BusinessObjectshelpers file located in the Add-ins Available list.

  6. Verify the Businessobjectshelpers box is checked in the Add-ins available list.
  7. Click OK.
  8. Open an Excel spreadsheet.
  9. Click the Add-Ins menu.

    10. Screenshot of the Add-Ins menu on the Excel toolbar and its custom toolbars

  10. Verify the Custom Toolbars are available.

If needed, you can test the Add-In using the following steps:

  1. Open the Excel spreadsheet on which you want to use the Add-In.
  2. Highlight the column and rows you want to copy into BusinessObjects.
  3. Click the Add-Ins menu, then click SQL.
  4. In the BusinessObjects List Delimiter Version 2.0 window, change the Delimiter to a semicolon (;).
  5. Click Copy.
    • If there are more than 999 rows selected, the data is broken into batches. You have to select, copy, and paste each batch individually.
  6. Paste the data into a BusinessObjects report filter or wherever you want to use the files.

Remove BusinessObjectshelpers Add-In

  1. In Excel, click Options.
  2. Click Add-Ins.

    3. Screenshot of the Excel Options window showing the Add-Ins option in the left-hand menu, the Manage Add-Ins drop-down list and the Go button.

  3. Click Go.
  4. Uncheck the Businessobjectshelpers box.

    5. Screenshot of the Add-Ins window showing the businessobjectshelpers box unchecked.

  5. Click OK.
  6. Click the Excel Options.
    • Clicking OK in the previous step closes the Options menu. It needs to be reopened.
  7. Click Add-Ins.

    8. Screenshot of the Excel Options window showing the Add-Ins option in the left-hand menu, the businessobjectshelpers add in in the add ins list, and the information about the file location.

  8. Click the Businessobjectshelpers row in the list of Add-Ins.
  9. View the Businessobjectshelpers.xlam location.
  10. Click OK.
  11. Navigate to the file location and delete the Businessobjectshelpers.xlam file.
    • If you installed or attempted to install the add-in multiple times, be sure to delete the file from all saved locations.
  12. Click the Excel Options.
  13. Click Add-Ins.
  14. Click Go.
  15. Click Businessobjectshelpers in the Add-ins list.

    16. Screenshot of the Add-Ins window showing the businessobjectshelpers row selected and the cannot be found message.

  16. Click Yes to the message that the Add-in could not be found and if it should be deleted from the list.
  17. Click OK.
  18. Open an Excel spreadsheet.
  19. Click the Add-Ins menu.

    20. Screenshot of the Add-Ins menu on the Excel toolbar and the SQL option.

  20. Right-click SQL and select Delete Custom Toolbar.