7.3 The Workbook Properties Dialog Box

The Workbook Properties Dialog Box-1.png

File Name Controls

Short Name

Specifies the short name of the Excel workbook.

Long Name

Specifies the long name of the Excel workbook.

Save As Group

Internal

Select this radio button if you want to save the Excel workbook internally to the project. After this radio button is selected and the project is saved, changes made to the Excel workbook in Origin will no longer affect the source Excel file. Changes made to the source Excel file will not affect the Excel workbook in the Origin project, either.

External

Select this radio button if you want to save a link connecting the active Excel workbook and its source Excel file when the project is saved. After this radio button is selected, changes made to the Excel workbook in Origin will affect the source Excel file. Also, changes made to the source Excel file will affect the Excel workbook in the Origin project.

When this radio button is selected and the project is saved, changes made to the workbook in Origin are reflected in the original source workbook. Additionally, changes made to the original source workbook file are reflected in the Origin project.

When this radio button is selected, Origin displays the full path and file name of the linked source file in the Linked File Path field.

Do not save, open as ready-only

This checkbox is available only when the External radio button is selected. When this check box is selected, the Excel workbook opened in Origin is ready-only. This means that changes made to the Excel workbook in Origin will not be saved to the source Excel file. However, changes made to the original source Excel file will be reflected in the linked Excel workbook in Origin.

Linked File Path Field

Relative to current project (OPJ) path

This checkbox specifies whether or not to save the location of the Excel file as a relative path to the current project file. For example, if the project file is saved to c:\ and the Excel file is c:\test\Data.xls, the relative path will be test\data.xls. Using relative path will increase the portability of the project and the Excel file.

When the Switch to OPJ Path upon Saving button is click, this checkbox is selected automatically.

Switch to OPJ Path upon Saving

Clicking this button will change the external Excel’s path to the path of the current project (OPJ). If the original path of the Excel file is not the same as the project path, a new copy of the Excel file will be created in the project path when the project is saved.

Sheet Name & Origin Index List

When you plot workbook data from multiple sheets, Origin uses @SheetNumber notations to denote these sheets that contain plotted data. To determine the numeric value of SheetNumber, Origin numbers the sheets in the order in which they are accessed for plotting. The workbook sheets and their associated SheetNumber values are listed in this list box.

Note: The first sheet of the workbook will always appear in this list box and its Origin Index will be blank.