File Sharing Problems

Co-Author an Excel Online Workbook in the Desktop App

Rana GarciaRana Garcia Nov 22, 2026 868 views

Question details

Two users want to edit the same Excel Online workbook simultaneously in the desktop application and synchronize their changes.

Co-Author an Excel Online Workbook in the Desktop App
Product
Microsoft Excel for the web and Excel desktop
Device & OS
not provided
Scenario
Both users need to open a shared cloud workbook in desktop Excel and work on it at the same time.
Observed behavior
Both users want their changes to synchronize in the shared workbook.
Before you start

Check that both users can sign in to their Microsoft accounts and have an updated version of Excel that supports co-authoring. Confirm that the workbook is in XLSX, XLSM, or XLSB format.

Solution 1Recommended

Share the cloud workbook and open it in desktop Excel

Use this method to let both users edit the same workbook and synchronize changes through OneDrive or SharePoint.

1
Store the workbook in the cloud

Save or upload the workbook to OneDrive, OneDrive for Business, or SharePoint. Open the cloud copy in Excel for the web.

2
Grant editing access

Select Share in the workbook, enter the other user's email address, and ensure the sharing permissions allow editing. Send the invitation or editing link.

3
Open the shared file in Excel

Have each user open the shared workbook link, sign in, and select Open in Desktop App in Excel for the web. The command's location can vary by interface.

4
Enable synchronization

In each desktop Excel window, check that AutoSave is on and that the cloud workbook is open rather than a downloaded copy. Both users can then edit the workbook at the same time.

5
Coordinate edits

Agree to work in different worksheets or cell ranges where practical. Check the shared workbook for each other's changes as you work.

Share the cloud workbook and open it in desktop Excel
Avoid editing the same cells: If both users change the same cell, the latest saved change may overwrite the earlier one.
Free Microsoft Office alternative

Work with Excel-compatible workbooks in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Its Excel format compatibility makes it easy to move existing workbooks into WPS, though it does not fix Microsoft Excel co-authoring issues.

Open and edit Excel-compatible workbooks, including XLSX filesUse a familiar spreadsheet interface for an easier transition from Microsoft OfficeWork with worksheets and cell ranges in a lightweight office suiteGet started for free
microsoft office alternative - wps office

Frequently Asked Questions

Can both users edit the workbook in desktop Excel at the same time?

Yes. Store the workbook in OneDrive or SharePoint, give both users editing access, and have each person open it in a compatible, updated version of desktop Excel while signed in.

Which file formats support Excel co-authoring?

Use a supported workbook format such as XLSX, XLSM, or XLSB. Check the file extension before sharing the workbook.

Why aren't the other user's changes appearing?

Make sure both users opened the same cloud file rather than separate downloaded copies, are signed in, and have AutoSave enabled in desktop Excel. Also check that each user has editing permission.

What happens if both users edit the same cell?

One change can overwrite the other. To reduce conflicts, agree on separate worksheets or cell ranges before editing.