Settings File Customisation

FluenceXL Excel Edition keeps all of its settings in a configuration file stored in the user's Application Data folder. This can be found here:

%appdata%\XLCubed Ltd\XLCubed Excel Edition\settings.xml

For a typical Windows installation, this will translate to:

C:\Users\USERNAME\AppData\Roaming\XLCubed Ltd\XLCubed Excel Edition\settings.xml

In order to customise the file for distribution to other users, you can open the FluenceXL add-in in Excel and change any settings that you desire, for example:

• Grid defaults
• Connections
• Favourite Grids
• FluenceXL Web server addresses
• FluenceXL Options

When you close Excel, the file will be updated, and can then be sent to other users, or including in a custom installation script.

Admin controlled

From Version 10.0.149 there are two additional files that can be added to the installation folder FluenceXL: (C:\Program Files (x86)\Fluence Technologies Inc\FluenceXL) AnaplanXL: installation folder (C:\Program Files (x86)\Anaplan\Anaplan XL Reporting)

• defaults.xml - will setup the default settings, the user can override them
• settings.xml - will force these settings, users can not change them

The format of the file is the same as the %appdata% version, you only need to include the settings you want to change/set. This is particularly important for the forced settings; only include those settings that you want to force onto the users.

See Also

• FluenceXL Silent Installation
• FluenceXL MSI Installation