KB All Products

slide

How do I activate or update my Office Connector Import license(s)?

Office Connector Import Before You Start During the installation of your software, you were prompted to identify the path for your License Folder.  The same path should have been used when performing the installation on all workstations because this provides a central location that all workstations look to for their […]
slide

How do I confirm that the Sage 100 Contractor API is installed correctly?

Background Liberty Reports for Sage 100 Contractor depends on the Sage 100 Contractor API being installed and working correctly. This component is provided by and supported by Sage. Steps You can check your installation of the Sage 100 Contractor API by following the steps below. This does not require you […]
slide

How do I restrict Sage 100 Contractor data from being viewed by specific people?

Background The security features of Sage 100 Contractor relate only to the menus and screens within Sage 100 Contractor and do not affect data-access from external sources (such as Microsoft Access, Crystal Reports, or Liberty Reports). This is because the security controls are implemented within the program (Sage 100 Contractor) […]
slide

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 […]
slide

How do I unload and load the Liberty Reports add-in?

Background This is a general-purpose article that provides steps for manually loading and unloading the Liberty Reports add-in. The resolution for certain technical issues require the add-in to be manually loaded or unloaded, and this action may also be prescribed by technical support staff. Steps Unloading the Liberty Reports Add-In […]
slide

There was a problem sending the command to the program

Symptom When you double-click a Microsoft Excel workbook or template (via Windows Explorer, your Windows desktop, Office Connector Launch Pad, or Liberty Reports Desktop), you receive one of the following messages: Windows 7 or Windows Server 2008 There was a problem sending the command to the program. Windows Vista Windows […]
slide

What are the latest service packs for Excel?

Summary Microsoft will, from time to time, publish service packs to the Microsoft Office suite. These service packs address a variety of issues including resolutions to known issues. Event 1 Software strongly recommends keeping current on the latest service packs and updates that are available for Microsoft Office as well […]
slide

How can Integrator be used with a Prolog database on a remote server?

Answer Integrator can be used with a Prolog database running on a remote server (e.g., a server that is outside your local area network infrastructure) provided that connectivity requirements and permission requirements are satisfied. Connectivity A Virtual Private Network (VPN) would be one means to connect your local environment to […]
slide

Why do I receive an error about zzUpdateOCLink when opening a workbook?

Symptom When opening an Excel workbook, the following message is displayed: Microsoft Excel (i) An unexpected error occurred in zzUpdateOCLink. Error 1004 You cannot use this command on a protected sheet. To use this command, you must first unprotect the sheet (Review tab, Changes group, Unprotect Sheet button). You may […]
slide

What are volatile Excel functions?

Definition of "Volatile" in Excel A volatile function is a worksheet function that can be used within an Excel formula just like many other functions that you may use on a regular basis. The key difference is that a volatile function will be recalculated whenever a calculation occurs on the […]