Template Issues

Create an Excel Template Users Can Copy and Edit

Huda QurayshiHuda Qurayshi Nov 13, 2026 870 views

Question details

Create an Excel template that users can copy and edit without changing the original.

Product
Microsoft Excel
Device & OS
not provided
Scenario
A template owner wants to share a reusable workbook while keeping the original unchanged.
Observed behavior
Users can create separate workbooks from the template and edit the permitted cells without modifying the original.
Before you start

Decide which cells users should edit and where you will store the original template. If using OneDrive or SharePoint, check that users can download the file while having view-only access to the original.

Solution 1Recommended

Save and share a protected Excel template

Use an Excel template and read-only sharing permissions to preserve the original while users create their own copies.

1
Prepare editable cells

In Excel, select the cells users may edit, open Format Cells, and on the Protection tab clear Locked. Leave other cells locked if they should remain protected.

2
Protect the worksheet

Go to Review > Protect Sheet, choose the actions users may perform, and apply protection. Set a password if you want to restrict who can remove it.

3
Save as a template

Select File > Save As, choose a location, and select Excel Template (*.xltx) as the file type.

4
Share the original with view access

Upload the .xltx file to OneDrive or SharePoint. Use Share or Manage access to give users view-only access, and ensure downloading is allowed.

5
Create and test a copy

Download the template and open the .xltx file in Excel to create a new workbook. Edit the intended cells, then use File > Save As to save the new workbook as an .xlsx file.

Check protection in the copy: Worksheet protection normally carries over to new workbooks created from the template. Test the editable cells and adjust the template if users need broader editing access. Worksheet protection is not a substitute for file-access permissions.
Work with reusable spreadsheets

Create an editable spreadsheet copy in WPS Office

Use WPS Spreadsheets to open a shared workbook and save a separate editable copy, while keeping the original in a view-only location.

  1. 1. Get the shared file: Download the view-only workbook or template from its OneDrive or SharePoint sharing link.
  2. 2. Open it in WPS: Launch WPS Spreadsheets and use Open to select the downloaded file.
  3. 3. Save a separate workbook: Choose Menu > Save As, select a local folder, and save the workbook with a new name as an Excel .xlsx file.
  4. 4. Edit the copy: Enter data in the permitted cells and save the .xlsx copy. If the sheet is protected, editing remains limited to unlocked cells unless protection is removed.
Save a separate copy without changing the shared originalOpen and save Microsoft Excel .xlsx workbooksEdit spreadsheets in a familiar interfaceUse WPS Office for free
microsoft office alternative - wps office

Frequently Asked Questions

Does an Excel template automatically protect the original?

No. Saving as .xltx makes the workbook reusable, but you should also use OneDrive or SharePoint sharing settings to give users view-only access to the original.

Why can't users edit cells in their new workbook?

Worksheet protection normally remains in a workbook created from a template. In the original template, select the cells users need, open Format Cells > Protection, clear Locked, and then apply Review > Protect Sheet again.

How do users create a workbook from the template?

Have users download and open the .xltx file in Excel. Excel creates a new workbook from the template; users can then select File > Save As and save it as an .xlsx file.

Can users edit every part of their own copy?

Only if the template allows it. Protected sheets restrict editing to permitted cells and actions. To allow unrestricted editing, remove sheet protection before saving the template or provide authorized users with the password.