Microsoft Office Excel

From Tools > Options > Microsoft Office Excel Options, you can specify the following for the Microsoft Office Excel add-in.

Preference	Description
Named Ranges Filtering Prefix	Sets a prefix to filter which Excel named ranges are exposed as parameters in a Workbench project. All named ranges defined in the Excel file that include that prefix are displayed as parameters in the project. By default, this setting is blank (no filter). If you specify a prefix, the prefix is used to filter the named ranges for all new design exploration systems. For example, if you set this option to WB, the Named Range Key property (in the Setup section of the Properties pane of the Microsoft Office Excel Analysis system) is set to WB for all new projects you create. If you have specified a different filtering prefix the project level in the Named Range Key property, the project-level setting is not affected by changes to this option.

Preference

Description

Named Ranges Filtering Prefix

Sets a prefix to filter which Excel named ranges are exposed as parameters in a Workbench project.

All named ranges defined in the Excel file that include that prefix are displayed as parameters in the project. By default, this setting is blank (no filter).

If you specify a prefix, the prefix is used to filter the named ranges for all new design exploration systems. For example, if you set this option to WB, the Named Range Key property (in the Setup section of the Properties pane of the Microsoft Office Excel Analysis system) is set to WB for all new projects you create.

If you have specified a different filtering prefix the project level in the Named Range Key property, the project-level setting is not affected by changes to this option.