Lesson 6.3 – Sharing & Collaboration in Excel

Lesson Overview

Sharing and Collaboration features in Excel allow multiple users to work together efficiently while maintaining data integrity. This lesson covers co-authoring, shared workbooks, comments, and tracking changes for team collaboration.

1. Co-Authoring in Excel

1.1 What is Co-Authoring?

• Allows multiple users to edit the same workbook simultaneously

• Requires OneDrive, SharePoint, or Microsoft 365

1.2 Steps to Enable Co-Authoring

1. Save workbook to OneDrive or SharePoint

2. Click Share → Enter email addresses → Send invitation

3. Users open workbook in Excel Online or Excel desktop

4. Changes appear real-time with colored cell indicators

1.3 Example

• Sales team updating monthly sales data simultaneously

• Project team tracking task completion in a shared workbook

2. Shared Workbooks (Legacy Feature)

2.1 Purpose

• Allows multiple users to edit an Excel file

• Tracks who made changes and when

2.2 Steps to Share Workbook

1. Go to Review → Share Workbook (Legacy)

2. Check Allow changes by more than one user at the same time

3. Save the workbook to a shared network drive

2.3 Notes

• Co-authoring is preferred for Microsoft 365 users

• Legacy shared workbooks have limitations (no slicers, tables, or conditional formatting updates)

3. Adding Comments & Notes

3.1 Comments

• For discussion and collaboration

• Steps: Right-click cell → New Comment → Type message

3.2 Notes

• For simple reminders or explanations

• Steps: Right-click cell → New Note

3.3 Example

• Comment on a sales figure asking for confirmation or explanation

4. Track Changes

4.1 Purpose

• Monitor who changed what and when in a workbook

• Useful for auditing and accountability

4.2 Steps to Track Changes

1. Go to Review → Track Changes → Highlight Changes

2. Select:

   • Track changes while editing

   • Highlight changes since last save

   • Choose which users to track

3. Changes are highlighted and can be reviewed

4.3 Example

• Track updates in a budget workbook shared with multiple departments

5. Best Practices for Collaboration

• Use cloud storage for real-time updates

• Avoid legacy shared workbooks for advanced features

• Use comments for discussion, not altering data

• Regularly save versions to avoid conflicts

6. Real-Life Examples

• Finance: Shared monthly expense reports with multiple accountants

• HR: Collaboration on employee performance tracker

• Sales: Team updating regional sales dashboards in real-time

• Project Management: Team tracking project milestones

7. Practice Questions

1. Share a workbook with your team using OneDrive for co-authoring.

2. Add a comment asking for clarification on a data entry.

3. Track changes in a shared workbook and review edits by a specific user.

4. Explain the difference between a comment and a note.

5. Discuss the advantages of co-authoring over legacy shared workbooks.