SaveToDB Options Dialog Box

The Options dialog box allows changing SaveToDB add-in options.

General Options

Interface language

The field allows changing the SaveToDB user interface language.
Restart Microsoft Excel to apply new settings.

Default data language

The field allows changing the default data language.
Developers must add translations to support this feature. See Developer Guide.
Use the Reload Workbook Tables... or Reload Data and Configuration button to reload data in a new language.

This workbook data language

The field allows changing the data language of the active workbook.
Developers must add translations to support this feature. See Developer Guide.
Use the Reload Workbook Tables... or Reload Data and Configuration button to reload data in a new language.
The add-in saves this setting in the workbook.

Encrypt connection string passwords by default

Check this option to encrypt connection string passwords by default.
The add-in encrypts the passwords using Microsoft Cryptography API. No one can access the passwords except for the user on this machine.

Encrypt connection string passwords in this workbook

Check this option to encrypt connection string passwords in this workbook only.
The add-in encrypts the passwords using Microsoft Cryptography API. No one can access the passwords except for the user on this machine.

Connection timeout

Use this field to set the server connection timeout.
You can increase this timeout for busy servers and slow lines and decrease it to get connection errors faster.

Command timeout

Use this field to set the timeout of the command execution.
Increase this timeout to update a large amount of database data.

Maximum number of lines in memory

Use this field to set the maximum number of lines stored in memory when generating commands to update data.
The add-in uses files to store generated commands when the limit is exceeded.
Usually, you have to set this option when working with large datasets on 32-bit Excel.

Maximum number of loaded rows (SELECT TOP)

Use this field to set the maximum number of lines loaded from a database.
Note that Excel supports 1M rows only.
The add-in shows a warning message when the loaded data reaches this limit.

Table row update mode

Use All Cells to save all columns in all rows where a user edited any cell, even without the changes.
Use Changed cells only to save columns with actual changes.
The first mode works faster and saves less data in the workbook.
The second mode can save time when many rows are edited but stay unchanged. For example, if a user copied and pasted the entire column.
Developers can overwrite this setting for specific objects.

Excel Options

Rename SaveToDB Tab to Database

SaveToDB 8 and higher use the Database tab name instead of SaveToDB.
You can uncheck this checkbox to have the last name.

Hide Advanced Menu Items

Check this checkbox to hide advanced menu items.
You can customize the advanced menu items using the Customize Ribbon dialog box.
You can also hide and unhide advanced items using the Hide Advanced Menu Items checkbox.

Show the Information group at the ribbon

Uncheck this checkbox to hide the Information group on the ribbon to free the ribbon place.

Number of values in parameter history

This field defines the limit of stored parameter values.
The maximum value is 1000.
See also Parameters Group.

Show the Open URL menu

Check this checkbox to show the Open URL menu in the Excel context menu.
The add-in detects URLs automatically.

Show the Table Views menu

Check this checkbox to show the Table Views menu in the Excel context menu.
See also Views Group.

Apply Default Formats

Check these options to apply the default formatting for editable tables.
See details in Table Format Wizard.
Check NOT NULL columns to highlight empty cells of non-NULL columns. The add-in creates conditional formatting for such columns, and you can modify it yourself.
You can format boolean fields manually also using the Format Range as Checkboxes button of the Developer Tools Menu.

Advanced Options

Open the last workbook at the startup

Check this option to open the last opened workbook at the Excel startup.
Press Shift to disable this feature once.

Rotate cell values on double-click

Check this option to rotate cell values on double-click.

Filter source rows on double-click in pivot tables

Check this option to filter source rows on double-click in pivot tables.

Launch the calendar on double-click in date cells

Check this option to launch the calendar on double-click in date cells.

Change auto filters using the row over tables

Check this option to use the rows over the tables to change table auto-filters.

Create validation lists using object definitions automatically

Check this option to allow creating validation lists automatically.

Keep WrapText in Cell Editor

Check this option to keep the Wrap Text cell property when updating the cell from the Cell Editor.
This option breaks the Excel Undo.

Keep formulas on data refresh

Check this option to keep cell formulas on data refresh by default.
Note that developers can overwrite this option for specific database objects.

Keep comments on data refresh

Check this option to keep cell comments on data refresh by default.
Note that developers can overwrite this option for specific database objects.

Skip loading data if there are no insertions or deletions

Check this option to skip loading data on saving changes when UPDATE commands are used only.
This option can save your time on reloading large datasets.

Protect data loaded via OLEDB and ODBC

Check this option to allow the add-in to load data via OLEDB and ODBC and paste data into Excel tables instead of loading by using Excel QueryTable objects.
Use this option, for example, to prevent losing a precision of large numbers and milliseconds of datetimes.
See details in the "Sample 13 - Data Types".

SaveToDB 7/8 Options

Auto-activate table related windows

Check this option to allow the add-in to save and restore related windows automatically.
This feature works in Microsoft Excel 2007 and 2010 only. It is removed in SaveToDB 9.

Auto-arrange workbook windows

Check this option to allow the add-in to arrange windows automatically.
This feature works in Microsoft Excel 2007 and 2010 only. It is removed in SaveToDB 9.

Hide workbook windows in the Windows Taskbar

Check this option to allow the add-in to hide child windows in the Windows Taskbar automatically.
This feature works in Microsoft Excel 2007 and 2010 only. It is removed in SaveToDB 9.

Developer Options

Add SaveToDB Data Sheets

The button adds hidden sheets used by the SaveToDB add-in to store the configuration data.
The add-in automatically adds sheets when you connect to database objects using the Database Connection Wizard or to data service objects using the Web Data Connection Wizard.

Remove SaveToDB Data Sheets

The button deletes SaveToDB data sheets in the active workbook.
Use this button if you want to remove the SaveToDB add-in from a computer or remove the SaveToDB data from a workbook.

Show SaveToDB Data Sheets

The button shows the hidden SaveToDB data sheets of the active workbook.
You can unhide the sheets manually using the Visible sheet property in the Visual Basic Editor (Alt-F11).

Hide SaveToDB Data Sheets

The button hides the SaveToDB data sheets of the active workbook.

Clean SaveToDB Data Sheets

The button deletes SaveToDB configuration data except for the core information about the connected objects.
Use this option to clean the workbook before distribution.
Then reload workbook tables and query lists.

Log File TextBox

The textbox contains a path of the SaveToDB log file.
Specify the full path with a writable folder.

Browse

The button opens a dialog box to select the log file path.

SQL Queries CheckBox

Check this checkbox to log SQL queries sent to databases.

Metadata Loader CheckBox

Check this checkbox to log SQL queries used to load database metadata.

Operation Telemetry CheckBox

Check this checkbox to log the operation telemetry.

Open

The button opens the SaveToDB log file.

Open Installation Folder

The button opens the SaveToDB installation folder.
The Languages subfolder contains interface translation files.

Open Connection String Cache

The button opens an editor of the cached connection strings.
The SaveToDB add-in saves the connection string when a user successfully connects to a database.
Next time, it uses the cache to suggest a username and password when the user connects with a new workbook.
The add-in encrypts the connection strings using Microsoft Cryptography API. No one can access the strings except for the user on this machine.

Clean Image Cache Folder

The button cleans the cached images loaded from the web.
See details in the Images article.