Create an Excel Template Users Can Copy and Edit
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.
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.
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.
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.
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.
Select File > Save As, choose a location, and select Excel Template (*.xltx) as the file type.
Upload the .xltx file to OneDrive or SharePoint. Use Share or Manage access to give users view-only access, and ensure downloading is allowed.
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.
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. Get the shared file: Download the view-only workbook or template from its OneDrive or SharePoint sharing link.
- 2. Open it in WPS: Launch WPS Spreadsheets and use Open to select the downloaded file.
- 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. 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.

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.




