OneDrive File Issues

Fix Excel SharePoint Workbook Creating Duplicate Copies During OneDrive Sync

Olivia MillerOlivia Miller Nov 4, 2026 868 views

Question details

A macro-enabled Excel workbook stored in SharePoint creates duplicate copies and displays a red synchronization error when edited and saved.

Fix Excel SharePoint Workbook Creating Duplicate Copies During OneDrive Sync
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Windows Settings

Click the Start menu, go to "Settings", and navigate to "Apps" > "Apps & features".

2
Locate OneDrive Installations

Search for "OneDrive" in the app list to check if multiple versions of Microsoft OneDrive are installed on your system.

3
Uninstall the Older Version

Select the older or duplicate version of Microsoft OneDrive and click "Uninstall" to remove it completely.

4
Sign In and Sync

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.

Remove Duplicate OneDrive Installations and Re-sync
Verify Synchronization: Check your system tray to confirm only one OneDrive icon is active. Open the workbook, make a test edit, and save it to ensure no further duplicate copies are created.
Free Microsoft Office alternative

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.

Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and macro-enabled .xlsm files.Built-in WPS Cloud ensures stable, conflict-free file synchronization across all your devices.Lightweight application footprint that does not conflict with existing system processes.Familiar spreadsheet interface that requires zero learning curve for Excel users.
microsoft office alternative - wps office

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.