Section “Help”

  • Show help pages on the internet: When checked, the XL Toolbox will open the default internet browser and navigate to the XL Toolbox homepage whenever you invoke the help system. This will ensure that you get the most up-to-date information. You may also want to use this option if you simply don’t like the Windows help viewer and prefer to use your favorite browser.
  • Use custom browser rather than the system default: This setting is intended for power users who wish to use a certain, non-default browser for viewing help pages on the internet. The URL of the pages is given as the program’s single argument.

Section “Suppressible Messages”

Some informational messages can be suppressed after the user has acknowledged them. To make them reappear when appropriate, click the button “Reset to show all messages”.

Section “Privacy”

  • Do not remember worksheets and related settings: Daniel’s XL Toolbox remembers the cells of each worksheet that you selected for the various functions such as ANOVA or the Formula Builder. This is very convenient when you are using these functions multiple times and don’t want to have to select the same cell ranges over and over again. The information is stored in the Windows registry. If you are concerned about your privacy, you can turn off this “worksheet memory” by checking the “Do not remember” box in the preferences dialog. Worksheet- and chart-related settings are only stored for a certain number of days (90).
  • Check for updates online: When checked, the XL Toolbox will perform an update check when Excel® is started. You can determine the minimum interval (in days) between checks. The update check works as follows: If an internet connection exists, a text file that contains the most recent version number is downloaded; if no connection exists, the version check will silently fail. The first line of the downloaded text file contains the version number, which is compared with the installed version’s number. The URL of the file that is downloaded to obtain the latest version information is as follows: http://xltoolbox.net/versioninfo.txt

More options

  • Do not show the splash screen during startup: Check if you don’t want the XL Toolbox to display the splash screen with the current version number during startup.
  • Adjust Y axis tick label positions when opening a workbook: Excel’s default placement of Y axis labels is quite far away from the Y axis. If you (like the author) prefer to move the axis labels closer to the axis, check this box. Note however that Excel resets the position of the labels every time a workbook is re-opened. Therefore, this option was introduced as a user preference. Also note that for unknown reasons, the axis labels are repositioned by Excel when a chart is exported to a graphic file (there does not appear a way to circumvent this).
  • Add reports to end of worksheet list: When checked, reports will be added as the end of the worksheet list, rather than next to the currently acive worksheet. Use this option if the order of your worksheets is important and must be preserved.
  • Office Detect and Repair: This button appears in Excel 2007/2010 only and invokes the “Detect and Repair” program that was included as a start menu command in earlier versions of Excel. The “Detect and Repair” feature is integral part of an Office installation and may help to solve obscure problems.