Template Issues

Reuse an Excel Template Without Changing the Original

Amos GikundaAmos Gikunda Nov 18, 2026 868 views

Question details

Create a clean workbook for each pay period while keeping the original template available for reuse.

Reuse an Excel Template Without Changing the Original
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants to start each pay period with the same workbook layout and formulas.
Observed behavior
Each pay period has a separate workbook, and the original template remains unchanged.
Before you start

Open the original workbook and check that it contains the layout, formulas, and blank fields you want for each pay period. If it contains macros, use a macro-enabled format when saving the template and each completed workbook.

Solution 1Recommended

Save the workbook as a reusable Excel template

Use an Excel template to create a new workbook for each pay period without editing the template itself.

1
Open Save As

Open the original workbook in Excel, then select File > Save As and choose a location.

2
Choose a template format

In the file type list, select Excel Template (.xltx), or Excel Macro-Enabled Template (.xltm) if the workbook contains macros. Name the template and select Save.

3
Create a new workbook

For each pay period, locate the template in your file manager and double-click it to create a new workbook based on the template.

4
Save the pay-period workbook

Select File > Save As and give the new workbook a distinct pay-period name. Choose .xlsx for a standard workbook or .xlsm if you need to retain macros.

Save the workbook as a reusable Excel template
Avoid editing the template: Opening a template through Excel's File > Open can open the template itself for editing. Double-click the template in your file manager to create a new workbook instead.
Work with spreadsheets in WPS Office

Create a separate pay-period workbook in WPS Spreadsheet

Open your clean workbook in WPS Spreadsheet and use Save As to make a separate file for each pay period, leaving the original ready to reuse.

  1. 1. Open the original: Launch WPS Spreadsheet and use Open to select your clean Excel workbook.
  2. 2. Save a new copy: Select Menu > Save As, choose a location, and enter a distinct name for the current pay period.
  3. 3. Choose the workbook format: Select the Excel .xlsx format in the file type list and click Save.
  4. 4. Enter pay-period data: Fill in the new workbook and use Save to update the copy. Reopen the original and repeat Save As for the next pay period.
Keep a clean workbook for each new pay periodOpen and save Microsoft Excel .xlsx filesUse a familiar spreadsheet interfaceWork with a free, easy-to-use office suite
microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between XLTX and XLTM?

XLTX is an Excel template format for workbooks without macros. Choose XLTM in File > Save As when the template contains macros you need to retain.

How do I make sure I don't overwrite the original workbook?

Open the original and immediately select File > Save As. Give the copy a different name before entering data, then work in that copy.

Why did Excel open the template for editing instead of creating a new workbook?

Using File > Open can open the template file itself. Close it without saving unwanted changes, then double-click the template in your file manager to create a new workbook.

What format should I use to save a workbook created from a macro-enabled template?

Select File > Save As and choose Excel Macro-Enabled Workbook (.xlsm) if the new workbook needs to retain its macros.