Configuring the Excel Properties and Component

You can configure Excel component execution options such as timeout value and when to close the workbook.

  1. With a model open in the gateway that contains the Excel component, right-click the Excel component icon .
  2. Click Properties, and then click the Execution tab.
  3. In the General Options Timeout text box, enter 0.

    If set to 0, no timeout limit is enforced. For more information, see Configuring the Execution Properties.

  4. Click OK to save your changes.
  5. From the gateway, double-click the Excel component.
    1. Select the Advanced tab.
      Click Close workbook to close the opened workbook (when not selected, Excel and the workbook remain open after the model is executed), and then from the adjoining list select when job completes.

      For more information, see Using Advanced Options.

    2. Repeat the above step for each Excel component.
  6. Click OK to save your changes and to close the Excel Component Editor.