Reuse an Excel Template Without Changing the Original
Question details
Create a clean workbook for each pay period while keeping the original template available for reuse.

- 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.
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.
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.
Open the original workbook in Excel, then select File > Save As and choose a location.
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.
For each pay period, locate the template in your file manager and double-click it to create a new workbook based on the template.
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 a separate copy for each pay period
Use Save As if you prefer to keep the original as a regular workbook rather than a template file.
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. Open the original: Launch WPS Spreadsheet and use Open to select your clean Excel workbook.
- 2. Save a new copy: Select Menu > Save As, choose a location, and enter a distinct name for the current pay period.
- 3. Choose the workbook format: Select the Excel .xlsx format in the file type list and click Save.
- 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.

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.




