'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel and OneDrive Creating Duplicate Files on iPad
Question details
Users experience an issue where Excel files saved to OneDrive on an iPad automatically generate duplicate versions with 'Copy' or '1' added to the file name.
- Product
- Microsoft Excel, OneDrive
- Device & OS
- iPadOS (iPad)
- Scenario
- Saving and syncing Excel files to OneDrive with the AutoSave feature enabled on an iPad.
- Observed behavior
- Duplicate files are created during the saving process. The duplicated file usually contains the most recent changes, while the original file does not update properly.
Verify that your iPad has a stable internet connection and ensure the affected Excel document is fully closed on any other devices, such as a desktop PC or Mac.
Resolve Synchronization Conflicts and Refresh OneDrive
Clear sync delays and ensure your OneDrive app is fully synchronized to prevent AutoSave conflicts.
Duplicate files typically appear when AutoSave attempts to upload changes but encounters a locked file or network delay. Forcing a sync refresh can restore normal saving behavior.
Close the affected Excel file on your iPad. If you previously opened the file on a computer or through Excel for Web, close it there as well to release any file locks.
Open the OneDrive app on your iPad, navigate to the folder containing your Excel file, and swipe down on the screen to force the app to refresh the file list.
Look at the synchronization status icon next to your file in OneDrive. Wait until the cloud icon indicates that all pending uploads and downloads are completely finished before reopening the file.
Save the File with a New Name
Bypass the locked original file by manually saving the updated document under a completely new name.
Clear Excel Temporary Data on iPad
Clear corrupted cached data within the Excel app that may be causing AutoSave to malfunction.
Try WPS Office for Seamless Cloud File Management
If you frequently experience file conflicts, duplication bugs, or sync delays with Microsoft Excel and OneDrive on your iPad, consider switching to WPS Office. It provides a lightweight, highly compatible mobile editing experience with stable cloud synchronization.
- 1. Download WPS Office: Install WPS Office for free from the Apple App Store on your iPad.
- 2. Connect cloud storage: Open WPS Office, go to the 'Cloud' tab, and link your preferred cloud storage service.
- 3. Edit smoothly: Open your .xlsx files directly within WPS Office and enjoy stable auto-saving without duplicate file conflicts.
Frequently Asked Questions
Why does Excel add 'Copy' or '1' to my file name on iPad?
This happens when the AutoSave feature detects a synchronization delay or a file lock conflict. If Excel cannot safely overwrite the original file on OneDrive due to a slow network or because the file is open on another device, it creates a duplicate to prevent data loss.
Which file should I keep if a duplicate is created?
You should generally keep the duplicate file that has 'Copy' or '1' in the name, as it typically contains the most recent edits that could not be synced to the original file. Always open both files to verify your data before deleting the outdated version.
How can I prevent duplicate files from appearing in OneDrive?
To prevent duplicates, always ensure you have a strong and stable internet connection before editing cloud documents. Additionally, make sure to close the file on your PC or Mac before attempting to open and edit it on your iPad.
