Fix OneDrive Creating a Numbered Copy Instead of Opening the Existing Excel File
Question details
The user needs to stop Microsoft 365 and OneDrive from creating a numbered duplicate copy and open the existing Excel file from the correct synchronized OneDrive location.
- Product
- Microsoft 365, OneDrive, Excel
- Device & OS
- not provided
- Scenario
- User opens an existing Excel file stored in OneDrive and instead gets a duplicate with a number appended.
- Observed behavior
- Microsoft 365 reports that the Excel file must be moved to OneDrive and creates a numbered duplicate copy even when the file already appears to be stored in OneDrive.
Check that the file is located in the correct synchronized OneDrive folder and note its exact path before opening it from Excel or File Explorer.
Open the File from the Correct Synchronized OneDrive Folder
Use this when the file already exists in OneDrive but Microsoft 365 still creates a numbered copy; it verifies the actual synchronized path before opening.
A numbered copy is usually created because the file is being opened from a different folder than the one OneDrive expects. Opening from the exact synchronized OneDrive location prevents Office from treating it as a new cloud file.
Select the OneDrive cloud icon in the Windows notification area and make sure sync is active and signed in.
In File Explorer, select the OneDrive folder in the left navigation pane, not a shortcut or recent files list.
Browse to the exact folder that contains the original Excel file and confirm the file name has no numbered suffix such as (1).
Double-click the file or right-click it, choose Open with, and select Excel or WPS Office.
Move the File to the OneDrive Folder That Microsoft 365 Expects
Use this if the file is stored in a separate subfolder and OneDrive still forces an upload; relocating it to the recognized OneDrive location can stop the numbered copy.
Avoid OneDrive Duplicate File Workflows with WPS Office
WPS Office is a free, lightweight Office alternative that opens and edits Excel files directly from your local or OneDrive folders with full .xlsx compatibility, a familiar ribbon UI, and no forced cloud relocation workflow that creates numbered duplicates.
Frequently Asked Questions
Why is OneDrive making a numbered copy of my Excel file instead of opening the original?
This happens when Microsoft 365 does not recognize the file as being in the expected OneDrive location. Confirm the file is in the exact synchronized OneDrive folder and open it from File Explorer under OneDrive, not from a shortcut or recent list.
Does moving my file to the OneDrive root folder stop the numbered duplicate?
Often yes. Microsoft 365 may expect the file in the main OneDrive folder or the location shown in Save As. Move the file there, open it from that location, and then check whether the numbered copy is still created.
Can WPS Office open OneDrive files without creating duplicates?
Yes. WPS Office opens and saves Excel files from your synchronized OneDrive folder directly, without forcing the Microsoft 365 cloud relocation workflow that can create numbered copies.
Will WPS Office preserve my existing Excel formatting?
Yes. WPS Office supports .xlsx format and preserves formulas, formatting, and charts, so you can open and edit existing Excel workbooks with a familiar interface.
