From the Isight
Design Gateway
Edit menu, select Preferences.
The Preferences dialog box appears.
Expand the Components folder on the left side
of the dialog box, and select Excel.
In the Default workbook close option list, specify
the default behavior for the Excel workbook that is referenced with the
component.
You can choose to leave the workbook open after execution or to close
it after each execution of the component or after the entire job completes.
Click Save workbook as an output file parameter after execution
if you want new Excel components added to models to save
the modified workbook as the component’s output file parameter after
execution.
This setting can be changed for any individual Excel component instance
using the 
button on the Advanced tab of
the Excel Component Editor.
Note:
Selecting this option increases the execution time
for the Excel component (by however long it takes Excel to save the workbook).
Click Run auto-macros when loading Add-ins if
you want the Excel component to always load Excel add-ins that are installed
in the Excel application.
Auto-macros for add-ins are not invoked unless you select this preference.
An example in which running auto-macros for add-ins is required would
be if the add-in added menu items to the Excel application (which is
done through macros).
Note:
Selecting this option will increase the start-up time
for the Excel application when it is executed from the Excel component.
Click Truncate worksheets with numerous consecutive empty
rows if you want the Excel component to stop reading the
worksheet after numerous consecutive empty rows are found.
If this option is not selected, Excel often defines a much larger “Used
Range” than what is actually needed because of cell formatting. You
can use this option to load the worksheet into the editor faster.
Click OK to save your changes and to close the
dialog box.