How to Collaborate and Co-Author Excel Workbooks Simultaneously

Real-time collaboration is a cornerstone of modern workplace productivity. In Microsoft Excel, this capability is known as co-authoring. When you co-author a file, you and your colleagues can open and work on the same Excel workbook simultaneously. Changes made by any user are synchronized and visible to everyone within a matter of seconds.

Depending on the version of Excel being used, you can even see your colleagues’ active cell selections highlighted in distinct colors. This complete guide walks you through setting up and using Excel co-authoring across Windows, Mac, Web, Android, and iOS platforms.

Note: To access real-time co-authoring in desktop applications, you must have an active Microsoft 365 subscription and ensure that you have the latest version of Office installed.

Pre-requisites for Excel Co-Authoring

Before jumping into collaboration, specific technical requirements must be met to avoid file locking:

• Cloud Storage: The workbook must be stored on a supported cloud location, which includes OneDrive, OneDrive for Business, or a SharePoint Online library. Note: SharePoint On-Premises sites do not support co-authoring.
• File Format: The workbook must be saved in a modern format: .xlsx, .xlsm, or .xlsb. If your file uses an older format (like .xls), open it in Excel, navigate to File > Save As…, and change the file format.
• Supported Excel Versions: All users must use a version of Excel that supports co-authoring. These include:
• Excel for Microsoft 365 (Windows and Mac)
• Excel for the web
• Excel for Android / iOS
• Excel Mobile

Co-Authoring in Excel for Windows Desktop

Step 1: Upload and Open the Workbook

1. Open your web browser and upload or create a new workbook on OneDrive or SharePoint Online.
2. Select the filename to open it in Excel for the web.
3. In the upper-right corner, select Editing (or Viewing) > Open in Desktop.
4. If a yellow bar appears indicating Protected View, click Enable Editing.

Step 2: Share the Workbook

1. Select the Share button located in the upper-right corner of the desktop app.
2. Type the email addresses of your colleagues in the address box (separate multiple entries with a semicolon).
3. By default, recipients are granted edit access. You can modify permissions by selecting the Can edit dropdown menu.
4. Add an optional message, or choose Add a file summary with Copilot to automatically generate a document description.
5. Click Add (or Send) to deliver an email invitation.

Tip: If you prefer to send the link manually via chat or email, select Share > Copy link instead of hitting the Add button.

Step 3: Collaborate and Track Changes

Once your colleagues open the invitation link, they can choose to edit the file via the browser or select Edit in Desktop.

Ensure that AutoSave is toggled ON in the upper-left corner of your Excel window. You will know co-authoring is active when you see user profile pictures or initials appearing in the upper-right corner.

Co-Authoring in Excel for Mac Desktop

Step 1: Prepare the File

Ensure your file is saved in a .xlsx, .xlsm, or .xlsb format and hosted on OneDrive or SharePoint Online. Open the file from your cloud drive or via your browser, and select Open in Desktop App.

Step 2: Invite Your Team

1. Click Share > Invite People in the top right corner.
2. To restrict editing access, uncheck the can edit box; otherwise, leave it checked.
3. Input the target email addresses, add an optional message, and click Share.
4. To generate a direct link manually, press Esc, click Share > Copy link, and choose the appropriate viewing/editing permissions.

Step 3: Active Session Management

Your selection cursor will always display as green on your monitor, while your colleagues’ selections will appear in blue, purple, or other colors. Hovering your mouse cursor over a colored cell reveals the name of the person editing it. To instantly jump to a teammate’s active cell, click their profile icon in the top right and select Go to.

Co-Authoring in Excel for the Web

Working entirely within a web browser provides the most streamlined setup for real-time collaboration.

1. Open the workbook in Excel for the web via OneDrive or SharePoint.
2. Click the Share button at the top of the ribbon.
3. To customize permissions, click People in [Your organization] with the link can edit inside the Send Link dialog box to modify accessibility scopes.
4. Enter the emails, add a message, and click Send (or use Copy link for manual distribution).

When multiple users edit a web workbook, status messages in the upper-right corner will keep you updated (e.g., “2 other people are here”). You can also click Show Changes to view a comprehensive ledger of recent adjustments along with prior cell values.

Co-Authoring on Mobile Devices (Android & iOS)

Technical Requirements

• Download the official Microsoft Excel app from the Google Play Store or Apple App Store.
• Sign in with a valid Microsoft Account. Note that if your device screen size exceeds 10.1 inches, a premium Microsoft 365 subscription login is required to unlock editing capabilities.

Step-by-Step Setup

1. Open or create your document in the mobile app and tap File > Save As.
2. Select your cloud account (OneDrive or SharePoint) as the storage location, name your file, and hit Save.
3. Tap the Share icon in the upper right.
4. Tap Invite People to enter email addresses and manage standalone edit permissions, or select Share as link / Copy Link to share access over instant messaging apps.

To check who is currently working inside the document from your mobile screen, tap Share > Shared With (or look for the Editing label alongside user names).

Troubleshooting and File Recovery

How to Recover Past File Versions

If a collaborator makes an accidental edit, you can roll back changes using Version History. Before executing a restore operation, ensure all users have exited the co-authoring session.

• Windows Desktop: Go to File > Info > Version History. Select a timestamped version from the sidebar to inspect it, then choose Restore.
• Mac Desktop: Go to File > Restore > Browse Version History. Open the target historical save and click Restore.
• Excel for the Web: Navigate to the folder containing your file, right-click the file name, select Version History, review the options, and click Restore.
• Android / iOS: Tap File > History (or View Version History Online for iOS). Select a save state to either Make a Copy or Restore the file.

Fixing the “File is Locked for Editing” Error

The most common cause for getting a “Locked for Editing” prompt during a collaborative session is that one or more users opened the file using an outdated version of Excel that does not support co-authoring. When this happens, Excel locks the cloud file to protect its data structure, blocking real-time synchronization for everyone.

To resolve this issue, verify that every team member has a supported version of Excel active, has their account signed in correctly, and has AutoSave enabled.