Create a Parameter

Create a parameter to hold and manage a current value or values that you want to use in multiple places in a workbook.

For information about how to choose the parameter's properties, see About Parameter Properties.
  1. On the Home page, select the workbook to add a parameter to, click Actions, and then select Open.
  2. In the Data Panel click Parameters.
    Parameters button

  3. In the Parameters Pane, click Add.
    Add parameter button

  4. In the Name field, enter a unique name.
  5. Click Data Type and choose the type of data you want the parameter to accept.
    Data type selection options

  6. In the Available Values field select how you want specify the parameter's value.
  7. In the Initial Value field, choose how you want the parameter's initial value to be determined. If you don't want to use an initial value, then select Value and leave the value blank.
  8. Click OK.
  9. Click Save.