SaveToDB Options

SaveToDB Options

Options
The button displays the Options dialog box described below.
Excel Options
The button displays the Excel Options tab of the Options dialog box.
Hide Advanced Menu Items
The button turns on or off displaying advanced menu items.
Show Task Panes
The button displays task panes used to show images.
Show Cell Editor Task Pane
The button displays the task pane used to edit multiline cell values.
Show List Editor Task Pane
The button displays the tasks pane used to select cell values from validation lists in an easy way.

Options Dialog Box

Common Options

Interface language
The field allows changing the SaveToDB interface language.
The field contains only available languages.
You may add an interface language yourself. The language file contains about 600 lines to translate.
If you would like to translate the add-in, please contact us.
Default data language
The field allows changing the default language of the database data.
This feature is used to show business names in different languages instead of native database object and column names.
This feature requires configuring data translation in a database.
This workbook data language
The field allows changing the active workbook language of the database data.
This setting is stored in a workbook instead of Windows Registry.
Use this option to prepare the workbook before distribution.
Connection timeout
The field is used to change the server connection timeout.
You may increase this timeout for busy servers and slow lines, and decrease it to get connection errors faster.
Command timeout
The field is used to change the timeout of command execution.
You may increase this timeout if a large amount of database data is updated.
Generate single-line SQL statements for Microsoft SQL Server
Microsoft SQL Server supports inserting and updating data from subqueries.
The SaveToDB add-in may generate SQL codes using this feature. The code is more efficient, but it is not user-friendly.
You may check this checkbox to generate the user-friendly code.

Excel Options

Show the Open URL menu at the context menu
The field controls showing the Open URL menu in the Excel context menu.
Show the Table Views at the context menu
The field controls showing of the Table Views menu in the Excel context menu.
Auto-activate table related windows
The field controls the mode the auto-activating related windows.
This feature allows activating related windows when you select another sheet in the main Excel window and hiding related windows of the previously active sheet.
This feature is also used to implement master-detail interfaces in the SaveToDB add-in.
See Working with windows.
Auto-arrange workbook windows
The field controls the window auto-arrange mode.
You may resize or move Excel windows, and the SaveToDB add-in arranges them.
See Working with windows.
Hide workbook windows in the Windows Taskbar
The field controls auto-hiding of child windows in the Windows Taskbar.
This feature can be useful when workbooks contain many windows.
Launch the calendar on double-click
The field controls launching the calendar control on the double-click.
Use the Calendar to input dates into Excel cells.
See Working with the calendar.
Change auto-filters using the row over tables
The field controls the use of rows over the tables to change table auto-filters.
This feature is very useful if you frequently change table auto-filters.
See Working with auto-filters.
Open the last workbook at startup
The field controls auto-opening of the last opened workbook at the Excel startup.
This feature is very useful for developers.
You may press Shift to disable opening a workbook during startup.

Ribbon Options

Hide Advanced Menu Items
The field controls showing advanced menu items.
Show the Information group at the ribbon
Uncheck this field to hide the Information group on the ribbon to free the ribbon place.
Limit of parameter values
The field defines the limit of stored parameter values.
The maximum value is 1000.
See Parameters.

Developer Options

Add SaveToDB Data Sheets
The button adds hidden sheets that are used to store SaveToDB add-in data.
These sheets are required to support a complete set of SaveToDB features.
The sheets can be added through the Connection Wizard also.
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 to remove the SaveToDB data from a workbook.
This button does not delete data sheets with table views as the companion TableViews add-in can be installed separately.
Use the Table Views dialog box to remove these data sheets.
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 database objects.
Use this option to clean the workbook before distribution.
Reload workbook tables and query lists after the cleaning.
Open Installation Folder
The button opens the SaveToDB installation folder.
The Languages subfolder contains interface translation files.
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.