SaveToDB Options Dialog Box
Special offer: 50% discount ($1440) for ODataDB Enterprise until June 24, 2024

SaveToDB Options Dialog Box

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

General Options

SaveToDB Options form - 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

SaveToDB Options form - 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

SaveToDB Options form - 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

SaveToDB Options form - 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.