Protect an Excel Template While Allowing Users to Edit Copies
Question details
The user wants to prevent changes to an original Excel template while allowing recipients to edit their own copies.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A master template is shared with users who need to create editable copies without modifying the original.
- Observed behavior
- Password protection applied to the original also prevents recipients from editing the copy.
Check whether the workbook or its worksheets are protected in Excel's Review tab. Identify a SharePoint location where you can manage access to the master and where recipients are allowed to download files.
Protect the master template with SharePoint permissions
Use file access permissions to protect the original while recipients download and edit separate copies.
Worksheet protection controls editing inside a workbook and can remain in a downloaded or copied file. Permissions on the SharePoint master protect the original location instead.
A read-only master does not guarantee that every copy will be editable: remove any worksheet or workbook protection that recipients should not inherit, provided you have permission to do so.
Open the template in Excel and check Review for protected sheets or workbook structure. If recipients need those areas editable, use Unprotect Sheet or Unprotect Workbook and enter the password if required.
In your SharePoint document library, select Upload and add the prepared template to the location reserved for the master.
Select the file's More options menu, open Manage access, and give recipients view-only access while reserving edit access for authorized maintainers. Check for other group or inherited permissions that might still grant recipients edit access.
Ask a recipient to open the shared library, select the template's More options menu, and choose Download. They can open the downloaded file in Excel and save their own working copy.
Using a recipient account, try to edit the SharePoint master, then download a copy and edit the intended cells in Excel. If download is unavailable, ask the SharePoint administrator to review the applicable sharing and download settings.

Distribute an Excel template file from a restricted location
Use the Excel template format to encourage users to start a new workbook, while protecting the master with separate permissions.
Work with Spreadsheet Templates in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easier move between apps. Use WPS Spreadsheet to work with template copies; protect the master separately through your storage permissions.

Frequently Asked Questions
Why is my copied Excel sheet still protected?
Worksheet protection can remain in a copied worksheet or workbook. In Excel, check Review > Unprotect Sheet and provide the password if one is required and you are authorized to remove it.
Does saving a workbook as an Excel template protect the original?
No. File > Save As > Excel Template creates a template file, but anyone with sufficient access to its location may still change it. Use SharePoint or other storage permissions to restrict the master.
Can users download a SharePoint file if they have view-only access?
Often they can, but download may be blocked by sharing settings or organizational policies. Test the file's More options > Download command with a recipient account and ask an administrator to review the settings if needed.
How can I recover a changed SharePoint master?
In the SharePoint document library, open the file's More options menu and select Version history. Choose an earlier version to restore it if version history is enabled and you have the necessary permissions.




