Constantly getting Onedrive sync errors on certain shared excel spreadsheets

Question

Hi,

I am encountering an issue with excel spreadsheets and OneDrive syncing. The users have synced a document library from SharePoint online and a few excel spreadsheets within them are forever getting "unable to update changes" and merge errors.

I have tried a OneDrive reset, removing folders synced to reduce load, internet speeds have been upgraded, opened and repaired the excel spreadsheet and cleared office cache but none of the aforementioned has worked.

The file is a .XLSX file and is 276kb.

Has anyone experienced this before and would mind sharing your solution?

Answer 1

Could you share us a screenshot of your issue？

From your description, you may try steps in this link.

Troubleshoot OneDrive for Business sync issues - SharePoint | Microsoft Learn

When a conflict is detected, you may see a sync error notification briefly. After that, the OneDrive for Business icon will display an error indicator in your system tray.

To resolve the conflict, right-click or press and hold the OneDrive for Business icon, and then choose Resolve. You will see the options available for your conflict.

If a conflict occurred with an Office file type, you should see the following options:

• Open to Resolve opens the file in a coauthor view. First select Save to refresh the open copy with the new content. That will appear highlighted, so you can easily reconcile changes.
• Save a Copy lets you save a copy of your version outside the synced folder.
• Discard discards your changes and fetches the new version from the server.

In most cases, you will you'll choose Open to Resolve.