| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Settings File Customisation"
(Created page with "XLCubed 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 Ex...") |
|||
| Line 13: | Line 13: | ||
When you close Excel, the file will be updated, and can then be sent to other users, or including in a custom installation script. | 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 XLCubed installation folder (C:/Program Files (x86)/XLCubed Ltd/XLCubed): | ||
| + | |||
| + | 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== | ==See Also== | ||
Revision as of 07:47, 15 December 2022
XLCubed 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 XLCubed add-in in Excel and change any settings that you desire, for example:
- Grid defaults
- Connections
- Favourite Grids
- XLCubed Web server addresses
- XLCubed 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 XLCubed installation folder (C:/Program Files (x86)/XLCubed Ltd/XLCubed):
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.
