FREE System Setup

The System Setup menu option provides the configuration information needed to open the Greentree connection, to set preferences, and for Greentree function call counting.

Options Reference

Each option and field on the form is described below. Mandatory options and fields are highlighted in red.

Bin Directory

This is the \bin folder being used by the workstation you are setting up (contains the JADE form files). For a Thin Client set-up this must be referenced from the servers point of view.

System Directory

This is the directory pointing to the Greentree database to be accessed. On a multi-user system this must be referenced from the servers point of view.

Ini File

If running a multi user system this needs to point to the .ini file that has the TCPServerPort of the Greentree Server, for example, if using a Thin Client connection it does not use the Application Server .ini file. Instead, it uses the .ini file of the Greentree Server, in which case it must be referenced from the point of view of the server.

Multi-user Greentree

This field is True if the workstation is accessing Greentree using a Greentree Server.

Open Greentree on Startup

This indicates whether the Greentree login dialog box displays when the Add-in is activated. Normally this occurs when Excel is first opened. It means that if a user normally works with Greentree when in Excel then they can set it up so that they login to Greentree with a password when Excel starts.

Update Worksheet Only

This indicates whether to update just the current worksheet, or all worksheets when the Refresh Data menu option is selected. If this box is selected when the Refresh Data menu option is selected, then only the current worksheet will be forced to recalculate by Excel and retrieve data from Greentree.

If there are dependencies from the current worksheet to other worksheets then these will be updated by Excel as part of its calculation process. If this box is not selected then all worksheets will be forced to recalculate and retrieve data from Greentree when the Refresh Data option is selected.

Hide Zeros doesn't do a Refresh

Set this flag to True if the hide zeros function may take a long time to run if a refresh is done each time, particularly if there are multiple hide functions within the worksheet(s). Otherwise, leave the flag as False.

Unhide all rows and columns before doing a Refresh

If this is selected, a Refresh will unhide all cells before refreshing. Note that if this is selected, the refresh process may be slow.

Display update results form

If you select this option, a transaction update results form displays during the update process. The update form confirms successful updates and highlights any failures if applicable.

This button will register the GreentreeInterface.dll.

warning It is not always appropriate to use the Register Greentree Interface option if you are setting your system up using DCom, as the Greentree setup path is not correct to register the interface locally. Check with your Greentree consultant for more information about setting up FREE using DCom.

Call Count On

This flag determines whether the Excel function calls are counted as they are being run. This option was installed to enable some basic performance monitoring to be carried out. Greentree function calls only are counted. This setting is also stored in the User's registry.

Call Counter

This is a view-only field that displays the number of Greentree function calls made since either Excel started, the Call Count On flag was set, or the Reset button was clicked.

Performance Tracking On

This feature provides performance-measuring statistics for function calls. It accumulates average elapsed times for both Excel and Greentree calls, along with totals.

Reset Count

This button resets the Call Counter back to zero.

Task Processing

Not available in the current version. This option allows selected spreadsheets to be updated at predefined intervals.

Some of the System Setup form is disabled when the Greentree database is open. Close the Greentree database first using the Login menu option to change any configuration settings that are read only.

When either OK or Apply is selected, the settings are stored permanently in the user's Windows registry so the configuration only must be done once for each user.