Collaborating and Sharing Excel Workbooks

Microsoft Excel provides powerful collaboration features that allow multiple users to work on the same workbook, leave comments, track changes, and manage different versions of a file. Whether working with colleagues in the same office or teams located around the world, these features improve communication, reduce duplicate work, and help maintain a single source of truth.

With Microsoft 365, Excel supports real-time co-authoring through OneDrive and SharePoint, allowing multiple users to edit a workbook simultaneously while preserving version history and protecting important information.

Learning Objectives

• Share Excel workbooks

• Collaborate using OneDrive and SharePoint

• Add comments and notes

• Use co-authoring features

• Review version history

• Compare workbook versions

• Protect shared workbooks

Why Collaborate in Excel?

Collaboration features allow multiple users to work together efficiently.

Benefits include:

• Real-time editing

• Faster decision-making

• Better communication

• Reduced duplicate files

• Improved version control

Sharing a Workbook

To share a workbook:

1. Save the workbook to OneDrive or SharePoint.

2. Click Share in the upper-right corner.

3. Enter the recipients' email addresses.

4. Choose editing or viewing permissions.

5. Click Send.

Recipients receive a link to the workbook.

Co-Authoring

Co-authoring allows multiple users to edit the workbook simultaneously.

When another user opens the workbook:

• Their cursor appears with their name.

• Changes are synchronized automatically.

• Updates appear in real time.

Co-authoring works only when the workbook is stored in OneDrive or SharePoint.

Adding Comments

Comments allow users to discuss specific cells without modifying the worksheet.

To add a comment:

1. Select a cell.

2. Go to Review → New Comment.

3. Enter your message.

4. Click Post.

Other users can reply, creating a conversation.

Notes vs Comments

Version History

Version History allows you to view and restore earlier versions of a workbook.

Steps:

1. Click the workbook name.

2. Select Version History.

or

File → Info → Version History

Excel displays previously saved versions with timestamps.

Comparing Workbook Versions

Comparing workbooks helps identify changes between different versions.

Typical comparisons include:

• Updated formulas

• Modified values

• Added worksheets

• Deleted records

Organizations often use version comparison during audits and financial reporting.

Protecting Shared Workbooks

Even when sharing workbooks, important information should remain protected.

Examples include:

• Locking formulas

• Protecting worksheets

• Restricting editing

• Password-protecting sensitive files

These measures prevent accidental changes.

Using OneDrive and SharePoint

OneDrive and SharePoint provide centralized cloud storage for Excel workbooks.

Advantages include:

• Automatic saving

• Real-time collaboration

• Version history

• Secure sharing

• Access from multiple devices

Collaboration Best Practices

• Save workbooks in OneDrive or SharePoint.

• Use comments instead of editing other users' work directly.

• Review version history before restoring files.

• Protect important formulas.

• Remove unnecessary sharing permissions.

• Communicate changes with team members.

Common Mistakes

• Sharing local files instead of cloud versions.

• Overwriting colleagues' changes.

• Ignoring version history.

• Giving unnecessary editing permissions.

• Leaving outdated comments unresolved.