.
.
.


https://support.office.com/en-us/art...b-779df08957a3

You will want to place your "template workbook" here: C:\Users\My\AppData\Roaming\Microsoft\Excel\XLSTAR T (change the My to your computer name).

Automatically open a workbook template when you start Excel
You can save workbook settings that you frequently use in a workbook template, and then automatically open that workbook template every time you start Excel.

To use a workbook template, create a workbook that contains the sheets, default text (such as page headers and column/row headers), formulas, macros, styles and other formatting that you want to use every time you use the template.

Settings that can be saved in a template:

Cell and sheet formats.

Page formats and print area settings for each sheet.

Cell styles.

The number and type of sheets in the workbook.

Protected and hidden areas of the workbook. You can hide sheets, columns and rows to prevent changes to workbook cells.

Text you want to repeat, such as page, column and row labels.

Data, graphics, formulas, charts and other information.

Data validation settings.

Macros, hyperlinks and ActiveX controls on forms.

Workbook calculation options and window view options.

To create a template, do the following:

Click File > Save As.

In the Save as type box, click Template.

In the Save in box, select the folder where you want to store the template.

In the File name box, do one of the following:

To create the default workbook template, type Book.

To create the default worksheet template, type Sheet.

To create a custom workbook or worksheet template, type the name you want to use.

Click Save.

Click File > Close.