The settings dialog box in the Excel add-in allows you to adjust your Macrobond account credentials, communication settings, and document directories directly from the Excel add-in.

Account

In the account tab, your Macrobond username and password, as provided by your sales representative, are stored. These credentials enable access to the database packages included in your license.

Communication

In this tab, you can define settings for a proxy server if it is not detected automatically. Additionally, it’s possible to specify the URL of the Macrobond server. In most cases, however, the default option should remain selected.

The ‘Automated configuration’ button lets you test a number of communication configurations to see what works best for your system.

Selecting ‘Verify end-to-end encryption for https’ verifies that the communication is encrypted between the application and the Macrobond servers and detects if anyone is eavesdropping on the communication. The option might not work in some networks where a firewall is configured to intercept and inspect all internet traffic.

Advanced

The 'Enable application logging' option logs more detailed diagnostically relevant information. Because turning on this function may impact application performance negatively, it should only be turned on when prompted by Macrobond support.

Checking ‘Enable SQL database connector log console’ activates a popup window providing details about the communication with your SQL server. This option should be used when creating or troubleshooting the SQL in-house data storage.

Document paths

In this tab, you can specify a location on your computer where you’d like to save the Macrobond documents that you choose to save locally rather than on the Macrobond server. By default, the Macrobond folder is located in your Documents folder.

Furthermore, you can add and name frequently used directories for easy access when opening and saving documents.