Fix Excel SharePoint Workbook Creating Duplicate Copies During OneDrive Sync
Question details
A macro-enabled Excel workbook stored in SharePoint creates duplicate copies and displays a red synchronization error when edited and saved.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening, editing, and saving a macro-enabled workbook synchronized from SharePoint via Windows Explorer.
- Observed behavior
- A red synchronization error appears in Windows Explorer, and Excel generates a new duplicate copy of the workbook instead of saving changes to the original file.
Ensure you save a local backup of your recent workbook edits to a different folder on your computer to prevent data loss while troubleshooting the synchronization issue.
Remove Duplicate OneDrive Installations and Re-sync
Multiple installations of the OneDrive client can cause synchronization conflicts and duplicate file generation. Uninstalling the conflicting older version resolves the error.
When two different versions of the OneDrive client are running on the same computer simultaneously, they interfere with AutoSave and SharePoint synchronization. This causes Excel to fail when overwriting the original file, forcing it to save a new duplicate copy instead.
Click the Start menu, go to "Settings", and navigate to "Apps" > "Apps & features".
Search for "OneDrive" in the app list to check if multiple versions of Microsoft OneDrive are installed on your system.
Select the older or duplicate version of Microsoft OneDrive and click "Uninstall" to remove it completely.
Sign in to the remaining, updated OneDrive client with your Microsoft 365 account. Open SharePoint Online in your web browser, navigate to your document library, and click "Sync" to restart the synchronization.

Try WPS Office for Seamless Document Management
If persistent Microsoft Excel and OneDrive sync issues disrupt your workflow, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with its own reliable cloud storage solution to prevent duplicate file errors.

Frequently Asked Questions
Why does Excel create a copy of my file with my computer name appended?
This typically occurs when multiple users edit a file simultaneously without co-authoring enabled, or when your local OneDrive client experiences a synchronization conflict and creates a secondary file to prevent overwriting someone else's work.
Do macro-enabled (.xlsm) workbooks affect OneDrive synchronization?
Yes, macro-enabled workbooks can sometimes trigger AutoSave restrictions and strict sync rules in SharePoint or OneDrive. Ensuring you have the latest OneDrive client and correct library permissions minimizes these sync interruptions.
How do I fix a red synchronization error icon in Windows Explorer?
A red X indicates a sync failure. You can resolve this by pausing and resuming the sync via the OneDrive system tray icon, checking for invalid characters in file names, or resetting the OneDrive client entirely.
Can I stop OneDrive from creating duplicate files automatically?
To prevent duplicate files, ensure only one OneDrive client is running on your computer, enable the AutoSave feature in Office application settings, and verify that no third-party backup software is locking your files.




