Share an Excel Template Online So Colleagues Can Create a Copy
Question details
Share an Excel template so colleagues can open it online and create personal copies without editing the original workbook.

- Product
- Microsoft Excel for the web with OneDrive or SharePoint
- Device & OS
- not provided
- Scenario
- A workbook owner wants to distribute a reusable Excel template through a link while preserving the original file.
- Observed behavior
- Ordinary shared Excel workbooks do not generally provide a direct duplication link, so recipients need to create a copy through Excel for the web.
Upload the finished template to OneDrive or a SharePoint document library before sharing it. Confirm that the workbook does not contain confidential sample data, because anyone with the link may be able to view it depending on your sharing setting.
Share the workbook as view-only and ask recipients to save a copy
Use this method for a standard Excel workbook when you need colleagues to access the template online without changing the original.
View-only access protects the source workbook. Recipients can open the shared file in Excel for the web and use Save As to place an editable copy in their own OneDrive or download one.
In OneDrive or a SharePoint document library, select Upload > Files and choose the completed Excel workbook.
Select the workbook, choose Share, and select a permission such as Can view. Choose the appropriate audience, such as people in your organization or specific people, then select Apply.
In the Share pane, select Copy link and send it to colleagues with instructions not to request edit access to the original.
Recipients should open the link in Excel for the web, select File > Save As > Save a Copy, and choose a location in their own OneDrive. If needed, they can select File > Save As > Download a Copy instead.

Distribute the file as an Excel template for repeated local use
Use this option when recipients mainly work in the desktop Excel app and need a new workbook based on the same design each time.
Share and Reuse Excel Templates with WPS Office
If Microsoft Excel for the web does not provide the duplication workflow you need, WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface. You can open Excel templates, create a separate working copy, and share compatible files while moving between Microsoft Office and WPS Office formats.

Frequently Asked Questions
Can I make an Excel link automatically force every recipient to create a copy?
Not for ordinary shared Excel workbooks in OneDrive or SharePoint. Share the file with Can view permission and instruct recipients to use File > Save As > Save a Copy in Excel for the web.
Which permission should I select to stop people from editing my original Excel template?
In OneDrive or SharePoint, select the workbook > Share, then choose Can view rather than Can edit. This prevents recipients from changing the shared source workbook.
Where does Save a Copy put the new workbook in Excel for the web?
After selecting File > Save As > Save a Copy, the recipient chooses a location in their own OneDrive. The copied workbook becomes a separate file that they can edit.
What can recipients do if they do not have OneDrive storage available?
They can open the shared workbook in Excel for the web and select File > Save As > Download a Copy. They can then save and edit the downloaded workbook locally.
Should I use an XLSX file or an XLTX file for a shared template?
Use XLSX for the most reliable browser-based sharing and tell users to save a copy. Use XLTX when recipients will usually download and open the template in the Excel desktop app to create new workbooks.




