Edit Worksheet dialog: Parameters tab

Use this tab to manage existing parameters and create new parameters. For example, you might want to delete parameters from a worksheet, or change the order that parameters are displayed when worksheet end users are prompted for parameter values.


This dialog is also displayed as:
Worksheet Wizard dialog: Parameters page

For more information, see:

"What are parameters?"

"About using parameters"

"About designing workbooks for maximum performance".

Available parameters

This list shows which parameters are available to the current worksheet and enables you to select parameters to edit, delete, and re-order.

To turn off a worksheet parameter, you can either delete the parameter or deactivate the parameter. Deactivate parameters as follows:

  • If the parameter is included in a condition, display the Conditions tab and clear the check box next to the condition containing the parameter, then click OK to close the dialog.

  • If the parameter is included in a calculation, display the Calculation tab and clear the check box next to the calculation containing the parameter, then click OK to close the dialog.

The order of parameters in the Available parameters list determines the order in which worksheet end users are prompted for parameter values.

Note: The Order column displays NA when a parameter is not active (that is, the parameter's underlying condition or calculation is not active).

Description

This field displays a user-friendly description of the currently selected parameter that is displayed when worksheet end users enter parameter values.

Hint: To change the description, click Edit and update the What description do you want to show other users? field.

New

Use this button to display the New parameter dialog (see "New Parameter dialog"). Use the "New Parameter dialog" to create new worksheet parameters that prompt worksheet end users for dynamic input.

Edit

Use this button to display the Edit parameter dialog (see "Edit Parameter dialog"). Use the Edit parameter dialog to edit the currently selected parameter.

Delete

Use this button to permanently remove the selected parameter. Worksheet users are no longer prompted to specify a parameter value for this parameter.

Note: When you remove parameters, you also remove items that are dependent on the parameter (for example, calculations, conditions). For example, if the parameter that you delete is used in a worksheet calculation, the calculation is also removed. To remove a parameter from a worksheet without deleting the parameter, deactivate it by removing the active condition or calculation that the parameter uses. For more information, see "How to deactivate parameters".

Move Up

Use this button to change the order of the currently selected parameter in the Available parameters list. The order of parameters in the Available parameters list determines the order in which worksheet end users are prompted for parameter values.

Move Down

Use this button to change the order of the currently selected parameter in the Available parameters list. The order of parameters in the Available parameters list determines the order in which worksheet end users are prompted for parameter values.

Notes

  • You are not allowed to delete parameters created for you by the Discoverer manager.