The Definitions group includes functionality for inserting model definitions, for example, parameters, variables, and functions, into the current worksheet. When inserting the data, a link, which keeps the data associated to the model, is also added in a form of a comment on a cell. You can edit the data in linked cells, and update the model definitions from data from the worksheet.

Click Parameters () to insert into the worksheet all global parameters from the open model. Parameters are added to the worksheet starting at the currently active cell, where a comment is also inserted linking the cell range to the model and the parameters nodes.

Click Parameters > Parameters Nodes () to only insert into the worksheet parameters listed in a selected Parameters node. This way you can easily limit the parameters you would like to expose in the worksheet.

Once inserted from the model, you can edit the expression, unit, and description of a parameter in the worksheet. To add a new parameter, enter it on the row below the last parameter in the cell range. Any changes to the parameters in the worksheet are detected and transferred automatically to the model. To manually update the model with data in the worksheet, see Update.

See Parameters for information about the corresponding VBA command.

Click Variables () to insert into the worksheet all variables from the open model. Variables are added to the worksheet starting at the currently active cell, where a comment is also inserted linking the cell range to the model and the variables nodes.

Click Variables > Variables Nodes () to import only variables from a selected variables node in the model.

Once inserted from the model, you can edit the expression and description of variables in the worksheet. The model is automatically updated with changes to variables in the worksheet. To manually update the model with data in the worksheet, see Update.

Click Functions () to insert function definitions from the open model. Functions are added to the worksheet starting at the currently active cell, where a comment is also inserted linking the cell range to the model and the function nodes.

In the worksheet, you can edit the inserted function definitions. After you edit a cell in a linked cell range, by default an update of the model is performed automatically. To manually update the model with the modifications in the worksheet, see Update.

To disable the automatic update for the model definitions, see Preference Settings.

Click Update () to update the open model with definitions found in the range of cells including the selected cell. The update requires that there is a link to the model within the cell range. The model is not updated if the open model does not correspond to the model referenced in the link. Using this button you can update parameters, variables, and functions.

See UpdateDefinitions for information about the corresponding VBA command.

Click Update > Update All () to update the model with all model definitions found in the current worksheet. Only cell ranges containing a link to a model are used for the update.

See UpdateAllDefinitions for information about the corresponding VBA command.

Click Update > Select () to open the Update Multiple window where you can select the cell ranges (linked to parameters nodes) to update.

In the Parameters section, select the cell ranges with parameters to be updated in the model. If you have edited functions or variables inserted into the worksheet, you can also select the corresponding Update checkboxes to update the model with the values from the worksheet. Click Update to apply the changes to the model definition in the open model, and to close the window. Click Cancel to close the window without updating the model.