File Sharing Problems

Share an Excel Template Online So Colleagues Can Create a Copy

Kushani NimanthikaKushani Nimanthika Nov 12, 2026 869 views

Question details

Share an Excel template so colleagues can open it online and create personal copies without editing the original workbook.

Share an Excel Template Online So Colleagues Can Create a Copy
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.
Before you start

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.

Solution 1Recommended

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.

1
Upload the template to OneDrive or SharePoint

In OneDrive or a SharePoint document library, select Upload > Files and choose the completed Excel workbook.

2
Set view-only sharing permissions

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.

3
Copy and send the sharing link

In the Share pane, select Copy link and send it to colleagues with instructions not to request edit access to the original.

4
Create a personal workbook copy

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.

Share the workbook as view-only and ask recipients to save a copy
The original remains protected: When recipients have view-only access and save their own copy, their edits are made in the new workbook rather than in your shared template.
Free Microsoft Office alternative

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.

Open and edit Excel template files without changing the original source file.Supports Microsoft Excel XLSX, XLS, and XLSM file formats for compatible collaboration.Familiar spreadsheet tools help users transition from Excel with minimal relearning.Lightweight installation and free access for everyday workbook editing and sharing.
microsoft office alternative - wps office

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.