Co-authoring in real time in Excel - Step-by-Step Guide

Introduction

Co-authoring in real time lets multiple people work on the same Excel file at the same time. This helps teams collaborate without sending files back and forth or waiting for others to finish.

When your team needs to update a budget spreadsheet together during a meeting

When multiple people are entering data into a shared sales report

When you want to review and edit a project plan with your colleagues simultaneously

When you need instant feedback on a financial model from your manager

When working remotely and everyone must see changes as they happen

Steps

Step 1: Save your Excel file to OneDrive or SharePoint

- File tab > Save As > OneDrive or SharePoint location

The file is stored online and ready for sharing

Step 2: Click Share button

- Top right corner of the Excel window

A sharing pane opens on the right side

Step 3: Enter email addresses of people to invite

- Sharing pane's 'Invite people' box

Recipients are listed for sharing

Step 4: Set permissions to 'Can edit'

- Sharing pane permission dropdown

Invited people can make changes to the file

Step 5: Click Send

- Sharing pane

Invitations are sent and collaborators can open the file

Step 6: Collaborators open the shared file in Excel or Excel Online

- Their OneDrive or SharePoint or email link

Everyone sees the same file and can edit at the same time

Step 7: Watch colored flags or cell highlights

- Within the Excel worksheet

You see where others are working and their changes appear live

Before vs After

Before

File saved locally on your computer, only you can edit it

After

File saved on OneDrive or SharePoint, multiple people edit simultaneously and see live changes

Settings Reference

Sharing permissions

📍 Sharing pane after clicking Share button

Controls whether collaborators can change the file or only view it

Default: Can edit

AutoSave

📍 Top left corner toggle in Excel window

Automatically saves changes so everyone sees updates immediately

Default: On when file is saved to OneDrive or SharePoint

Common Mistakes

Saving the file only on your computer and not to OneDrive or SharePoint

Others cannot access or edit the file in real time

Always save the file to OneDrive or SharePoint to enable co-authoring

Setting sharing permission to 'Can view' instead of 'Can edit'

Collaborators can only see the file but cannot make changes

Set permission to 'Can edit' to allow real-time collaboration

Turning off AutoSave

Changes are not saved automatically, causing delays in updates for others

Keep AutoSave on to ensure all edits are saved and visible instantly

Summary

Co-authoring lets multiple people edit the same Excel file at the same time online.

Save your file to OneDrive or SharePoint and share it with edit permissions.

Use AutoSave to see live updates and colored flags to track collaborators' work.