MicroStation CONNECT Edition Help

To Define Picklist Settings for Picklist Source as Named Range

  1. Select the Excel file from the drop-down list. You can also search for a picklist by name in the Search field.
    Note: Supported Excel file formats are .xlsx (Excel Workbook) and .xlsm (Excel Macro Enabled Workbook 2007 or later).
  2. Select the Picklist Option as Named Range from the drop-down menu.


    Note: The excel workbook must have Named Ranges.
  3. Select the Excel Sheet Name and Column Name from the drop-down list.
    Note: If the setting for First Row Contains Headingsis selected, the Cell Range must be start from 2. The fields for Picklist settings is enabled based on the Picklist Option selected. An error will be prompted in the message center if the Range settings are incorrect.
  4. Click Ok.
  5. Click on Save button on the Item Types dialog to save the Item type settings.
    Note: The selected values will appear in the properties of the selected Item type in the Attach Item dialog and the Picklist Option in Properties Dialog.


    The Corresponding Picklist values are displayed in the search drop-down list.



    Picklist Properties in the Properties Dialog.

Parent topic: Item Types Dialog