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.

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.

In any empty cell in your worksheet, type the following formula: =LRCreateToolbar()

Upon pressing enter, the formula will be evaluated by Liberty Reports resulting in the toolbar being displayed.

Clear the formula that was entered.

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