Using the COM Add-Ins Manager

Subtopics

You can start Microsoft Excel and then load or unload Crystal Ball using the COM Add-Ins Manager. You can also use this Microsoft Excel tool to set Crystal Ball to start whenever you start Microsoft Excel.

To use the COM Add-Ins Manager for these tasks, follow the instructions below for your version of Microsoft Excel:

Caution!

To avoid unexpected results, do not unload Crystal Ball while other COM add-ins are loaded in Microsoft Excel.

For Microsoft Excel 2003

  To load Crystal Ball within Microsoft Excel:

  1. Follow these steps to display a list of available COM Add-ins:

    • On the View menu, point to Toolbars, and then click Customize.

    • Click the Commands tab.

    • In the Categories box, click Tools.

    • In the Commands box, select COM Add-Ins and drag it to a toolbar, for example, the Microsoft Excel menu bar.

    • On the toolbar, click COM Add-Ins to see a list of available add-ins.

  2. In the COM Add-Ins dialog, select Crystal Ball.

  3. Click OK to close the dialog and open Crystal Ball within Microsoft Excel.

To unload Crystal Ball from within Microsoft Excel, follow step 1 and then clear Crystal Ball in step 2.

For Microsoft Excel 2007 or Later

  To load Crystal Ball within Microsoft Excel:

  1. Click the Office button, Office button or select the File ribbon.

  2. Click the Microsoft Excel Options button, and then click the Add-Ins link.

  3. In the Manage list at the bottom of the Add-Ins dialog, select COM Add-Ins and click Go.

  4. In the COM Add-Ins dialog, select Crystal Ball.

  5. Click OK to close the dialog and open Crystal Ball within Microsoft Excel.

To unload Crystal Ball from within Microsoft Excel, follow steps 1 through 3 and then clear Crystal Ball in step 4.