The Select List worksheet allows you to add or modify values for select lists and select list entries.
-
In the Excel file, select the Select List tab to display the Select List Definitions worksheet.
-
Place the cursor in the last cell of the table in Column G (Dependent List/Value) and press the Tab key to add a new table. The cursor moves to the first column of that row.
When adding new data rows on the worksheet, you must ensure that those rows are added inside the Excel table in which the headers are located. For more information about adding rows, refer to the Microsoft Excel Online Help topic Resize a table by adding rows and columns.
-
In the new row, enter values in the columns according to what you want to do as shown in the following table.
What do you want to do?
Current Select List
Select List
Current Value
Value
Create a new select list
Blank
<New value>
Blank
Blank
Modify an existing select list
<Existing value>
<New value>
Blank
Blank
Create a new select list entry in an existing select list
<Existing value>
<Existing value> or blank
Blank
<New value>
Modify a select list entry in a select list
<Existing value>
<Existing value> or blank
<Existing value>
<New value>
-
The Current Select List and Select List columns should be blank in the row where the values for the select list appear. Select list entry values that you want to add or modify are added in the succeeding rows below the row where the select list is entered.
-
It is not possible to modify a select list entry using the Metadata Import Utility if the current value of that select list entry in the database is blank. In such cases, the software ignores the blank database value and treats that value as if it were a non-existent row; that is, it creates a new select list entry.
-
-
In the Disable column, select No for the select list entries you want to appear in the program interface.
-
To make another select list or select list entry dependent on a select list or select list value, type an appropriate value under the Dependent List/Value column.
-
Save the Excel file.