Named Cells as Parameters

The SaveToDB add-in lets you use Excel named cell values as query parameters.

For instance, you can create a named cell called account_id to manage the account_id parameter values.

Make sure to create these named cells with a worksheet scope.

If you prefer a workbook scope, use the global_ prefix, like global_account_id. With this setup, when a user changes the cell value or any account_id parameter, the add-in will automatically update all queries that reference the account_id parameter.

Keep in mind that if your workbook has many worksheets, this could lead to performance issues.

You can also use named cells with __name suffixes to retrieve the displayed value instead of the parameter value. For example, if account_id has a value list, the account_id cell will show an integer value, while account_id__name will display its corresponding name.