7.2 The Save Excel Workbooks dialog box

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 (Tools: 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.

The Save Excel Workbooks dialog box.png

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.

Note: All workbooks created by clicking the New Excel button Button New Excel.png on the Standard toolbar have the Internal radio button selected by default.

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 buttonButton Save Project.png 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.

Note: To re-enable the display of Save Excel Workbooks dialog box, select either Before Saving or Before Save Project As from the Saving Excel Workbooks drop-down list on the Excel tab of the Options dialog box (Window: Origin Options when an Excel workbook is active, or Tools: Options when an Origin child window is active).