7.3 The Workbook Properties Dialog Box

Specifies the short name of the Excel workbook.

Specifies the long name of the Excel workbook.

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.

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.

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.

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.

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.