7.2 The Save Excel Workbooks dialog box

ExcelRef-SaveWkbk-Dialog

This dialog box is only seen if you have selected Before Saving or Before Saving Project As from the Saving Excel Workbooks list on the Excel tab of the Options dialog box (Preferences: Options when the Origin workspace is active or Window: Origin Options when an Excel workbook is active). The dialog box will not be seen if the Never option is selected. Note that this dialog box has a Show this dialog list that lists the same three options. Changing the selection in this dialog box will update the Saving Excel Workbooks list.

Internal

This list box displays the workbooks in which the Internal radio button was selected from the associated Workbook Properties dialog box. These workbooks are saved as part of the Origin project file, not as an Excel file with a link to the project.

External

This list box displays the workbooks in which the External radio button was selected from the associated Workbook Properties dialog box. These workbooks are saved as a separate Excel file, with a link to the project.

If the check box next to the workbook is selected, then the source Excel file is updated when the project is saved. To ensure that this check box is selected by default, select the Update Automatically check box in the workbook's associated Workbook Properties dialog box.

Show this dialog

This drop-down list controls the display of this dialog box when you save a project that contains an Excel workbook.

• Select Never to prevent Origin from opening this dialog box under all circumstances.
• Select Before Saving to direct Origin to open this dialog box whenever you select File: Save Project or click the Save button on the Standard toolbar), assuming the project includes an Excel workbook.
• Select Before Saving Project As to direct Origin to open this dialog box whenever you select File:Save Project As, assuming the project includes an Excel workbook.