Excel for iPad Opens the Original OneDrive Template Instead of a Copy
Question details
Create a separate workbook from a OneDrive template on an iPad without editing the source file.

- 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.
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.
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.
In OneDrive, find the workbook and open it in Excel on your iPad. Avoid making changes to the original.
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.
Check the workbook name at the top of Excel to confirm that the copy is open, then make your changes there.

Restrict editing on the original OneDrive file
Use view-only access to reduce the risk of collaborators changing the source workbook.
Save the source as an Excel template file
Use an .xltx file when you want to identify the source as an Excel template rather than a regular workbook.
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.

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.




