Workbook Templates

Workbooks are created from templates. A workbook template file (*.OTW) contains instructions for constructing the worksheet. The template file saves such things as the number of sheets in the workbook, the number of columns in each worksheet, column plotting designations, mathematical formulae used to determine column values, and scripts associated with the worksheet.

For more information on workbook templates, see What is Saved with a Workbook Template?

Saving the workbook template

To save the active workbook as a template:

1. Select File: Save Template As. This menu command opens the Save As dialog box.
2. Specify a name (and folder) for the template. The OTW extension is automatically added.

Creating a new workbook from a custom template

To create a workbook based on a specific template:

1. Select File: New. This menu command opens the New dialog box.
2. Select Workbook from the Window Type list box.
3. If necessary, use the browse button to the right of the Path (Template group) to locate the OTW file.
4. Select the worksheet template from the Name drop-down list.
5. Optionally, specify this as the default workbook template by clicking Set Default