3305 Main Street Ste 019 Vancouver, WA 98663

Why is the Liberty Reports toolbar missing?

Background

Beginning with Liberty Reports version 1.0.37 the toolbar is created and displayed by a separate component named "Liberty Reports Ribbon" that is automatically installed with Liberty Reports. In some cases (e.g., Excel exits abnormally), the "Liberty Reports Ribbon" component may be disabled by Excel and this will prevent the toolbar from appearing.

Solution

Step 1 - Confirm that the Liberty Reports add-in is loaded.
Loading the Liberty Reports add-in will allow Liberty Reports functions and queries to work and will provide the functionality tied to the various buttons on the Liberty Reports ribbon.
Click here for instructions to load the Liberty Reports add-in.

Step 2 - Enable the Liberty Reports toolbar.
This assumes that the Liberty Reports ribbon may have been disabled.

  1. Open the Excel Options window.
    • Excel 2010 & above: Click the File menu (upper left), and then click Options.
  2. Click Add-Ins.
  3. In the Manage box, click Disabled Add-Ins, and then click Go.
  4. Select Liberty Reports Ribbon and click Enable.
  5. Click OK.

Step 3 - Load the Liberty Reports Ribbon
Loading the Liberty Reports ribbon will cause it to be displayed.

  1. Open the Excel Options window.
    • Excel 2010 & above: Click the File menu (upper left), and then click Options.
  2. Click Add-Ins.
  3. In the Manage box, click COM Add-Ins, and then click Go.
  4. Check the box for Liberty Reports Ribbon.
  5. Click OK.

Show The Alternate Toolbar
You can use this option if you are unable to display the Liberty Reports ribbon using the steps listed above. Note that this option will display an Excel 2003 style toolbar regardless of the version of Excel. With Excel 2007 and higher, this toolbar will reside on the Add-Ins tab of the ribbon.

  1. In any empty cell in your worksheet, type the following formula: =LRCreateToolbar()
  2. Upon pressing enter, the formula will be evaluated by Liberty Reports resulting in the toolbar being displayed.
  3. Clear the formula that was entered.

Note - If you later wish to remove this alternate toolbar, use: =LRDestroyToolbar()