OneDrive File Issues

Excel for iPad Opens the Original OneDrive Template Instead of a Copy

Khadija KhanKhadija Khan Nov 20, 2026 868 views

Question details

Create a separate workbook from a OneDrive template on an iPad without editing the source file.

Fix Excel for iPad Opening the Original OneDrive Template
Product
Microsoft Excel for iPad and OneDrive
Device & OS
iPadOS
Scenario
A user opens a workbook stored in OneDrive to use it as a template.
Observed behavior
Excel opens the original workbook rather than creating a separate copy, allowing changes to be made to the source.
Before you start

Locate the source workbook in OneDrive and check whether you have edit or view-only access. If you plan to use an Excel template file, check its extension and whether you can create it in desktop Excel.

Solution 1Recommended

Save a separate copy before editing the workbook

Use this method when Excel for iPad opens the original workbook and a copy option is available.

1
Open the source workbook

In OneDrive, find the workbook and open it in Excel on your iPad. Avoid making changes to the original.

2
Save a copy

In Excel, open the File menu or the three-dot menu and look for Save a Copy or Duplicate. Choose a OneDrive location and give the copy a distinct name.

3
Edit the new workbook

Check the workbook name at the top of Excel to confirm that the copy is open, then make your changes there.

Save a separate copy before editing the workbook
If the copy option is unavailable: In OneDrive, select the workbook and look for Copy to in its menu. Choose a destination, then open the copied file from that location. Available commands can vary by app version and permissions.
Free Microsoft Office alternative

Work with Excel-compatible spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and Excel-compatible formats, making it easier to move spreadsheet work to WPS. It does not change how Excel for iPad opens OneDrive templates, so make a separate copy and manage source permissions as needed.

Open and edit Excel-compatible XLSX workbooks.Use familiar spreadsheet controls when moving from Microsoft Office.Create a separate workbook for template-based work without editing the source.Use a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my OneDrive template open as the original workbook?

If the file is a regular workbook, Excel may open that file directly rather than create a new document. Before editing, use Save a Copy or Duplicate in Excel, or look for Copy to in OneDrive.

Will an .xltx file always create a new workbook on an iPad?

Not necessarily. Save the file as Excel Template (*.xltx) in desktop Excel, then test how it opens from OneDrive on the iPad. If a separate workbook is not created, make a copy manually.

How can I stop other users from changing the original?

In OneDrive, select the file and use Share or Manage access to give users view-only access. Review existing edit permissions as well; a view-only link does not remove separate edit access.

What can I do if Save a Copy is missing in Excel for iPad?

Return to OneDrive, select the workbook, and look for Copy to in the file menu. Choose a destination and open the copied file. The available options depend on the app version and your permissions.