Sharing workbooks in Excel - Step-by-Step Guide

Introduction

Sharing workbooks lets you and others work on the same Excel file at the same time. It helps teams collaborate without sending multiple copies back and forth.

When your team needs to update a sales report together in real time

When you want to collect data from multiple people in one file without merging later

When you are working on a project plan and want everyone to see changes immediately

When you want to review and edit a budget with your manager simultaneously

When you want to avoid confusion from multiple versions of the same workbook

Steps

Step 1: Click

- File tab

The backstage view opens showing file options

Step 2: Click

- Share

Sharing options appear on the right side of the screen

Step 3: Click

- Save to Cloud (OneDrive or SharePoint)

Workbook is saved online to enable sharing

Step 4: Type

- Invite people box

You enter email addresses of people to share with

Step 5: Select

- Permission dropdown

You choose if people can edit or only view the workbook

💡 Choose 'Can edit' to allow collaboration

Step 6: Click

- Send button

An email invitation is sent with a link to the shared workbook

Step 7: Open

- Shared workbook

You and others can work on the workbook at the same time and see changes

Before vs After

Before

Workbook is saved only on your computer and only you can edit it

After

Workbook is saved on OneDrive and shared with others who can edit or view it simultaneously

Settings Reference

Permission level

📍 Share pane under Invite people box

Controls whether invited users can change the workbook or only see it

Default: Can edit

Save location

📍 File tab > Save As > OneDrive or SharePoint

Stores the workbook online so it can be shared and edited by multiple users

Default: OneDrive personal

Common Mistakes

Trying to share a workbook saved only on your local computer

Others cannot access or edit the file if it is not saved online

Save the workbook to OneDrive or SharePoint before sharing

Giving 'Can view' permission when you want others to edit

Users can only see the file but cannot make changes

Select 'Can edit' permission when inviting people

Summary

Sharing workbooks lets multiple people work on the same Excel file at once.

You must save the workbook to OneDrive or SharePoint to share it.

Set permissions to control if others can edit or only view the workbook.

Practice

1. What is the main purpose of sharing a workbook in Excel?

easy

A. Allow multiple users to edit the same file simultaneously

B. Protect the workbook with a password

C. Convert the workbook to a PDF file

D. Create a backup copy automatically

Solution

1. Step 1: Understand workbook sharing

   Sharing a workbook allows several people to work on the same Excel file at the same time.

2. Step 2: Identify the main purpose

   The main goal is to enable collaboration by letting multiple users edit simultaneously.

3. Final Answer:

   Allow multiple users to edit the same file simultaneously -> Option A

4. Quick Check:

   Sharing workbook = multiple users editing [OK]

Hint: Sharing means multiple people can edit together [OK]

Common Mistakes:

• Confusing sharing with password protection
• Thinking sharing creates backups automatically
• Assuming sharing converts file formats

2. Which of the following is the correct way to start sharing a workbook in Excel?

easy

A. Click Home > Format > Share Workbook

B. Click File > Save As > Share Workbook

C. Click Review > Share Workbook > Allow changes by more than one user

D. Click Insert > Share Workbook

Solution

1. Step 1: Locate sharing option in Excel

   The Share Workbook feature is found under the Review tab.

2. Step 2: Choose correct menu path

   Click Review > Share Workbook, then check the box to allow multiple users to edit.

3. Final Answer:

   Click Review > Share Workbook > Allow changes by more than one user -> Option C

4. Quick Check:

   Sharing option is under Review tab [OK]

Hint: Sharing is under Review tab, not File or Home [OK]

Common Mistakes:

• Looking for sharing under File or Insert tabs
• Confusing Save As with sharing options
• Not enabling the checkbox for multiple users

3. If you share a workbook and two users edit the same cell at the same time, what happens?

medium

A. Excel shows a conflict message to choose which change to keep

B. Excel locks the cell and prevents any changes

C. Excel automatically merges both changes without asking

D. Excel deletes the cell content

Solution

1. Step 1: Understand cell conflict in shared workbooks

   When two users edit the same cell, Excel detects a conflict.

2. Step 2: Identify Excel's behavior on conflict

   Excel prompts users with a conflict message to decide which change to keep.

3. Final Answer:

   Excel shows a conflict message to choose which change to keep -> Option A

4. Quick Check:

   Conflicts prompt user choice [OK]

Hint: Conflicts prompt a message to resolve edits [OK]

Common Mistakes:

• Assuming Excel merges changes automatically
• Thinking Excel locks the cell permanently
• Believing Excel deletes data on conflict

4. You shared a workbook but your colleague cannot see your changes. What is the most likely reason?

medium

A. You forgot to save the workbook after editing

B. You did not protect the workbook with a password

C. Your colleague is using a different version of Excel

D. The workbook is not saved on a shared network or cloud location

Solution

1. Step 1: Check sharing location

   For sharing to work, the workbook must be saved on a shared network or cloud location accessible to all users.

2. Step 2: Identify common cause of changes not visible

   If the file is saved locally on your computer, others cannot see your changes.

3. Final Answer:

   The workbook is not saved on a shared network or cloud location -> Option D

4. Quick Check:

   Shared file location needed for collaboration [OK]

Hint: Save workbook on shared/cloud location for visibility [OK]

Common Mistakes:

• Assuming saving locally shares changes
• Blaming Excel version differences first
• Confusing password protection with sharing

5. You want to share a workbook with your team and track changes made by each user. Which steps should you follow?

hard

A. Save locally, share via email, and protect workbook with password

B. Save the workbook on OneDrive, use Share button, and enable Track Changes

C. Save on USB drive, share manually, and disable Track Changes

D. Save on desktop, use Share Workbook feature without Track Changes

Solution

1. Step 1: Save workbook on cloud for sharing

   Saving on OneDrive or similar cloud allows easy sharing and simultaneous editing.

2. Step 2: Use Share button and enable Track Changes

   Sharing via the Share button lets team edit together; enabling Track Changes logs edits by each user.

3. Final Answer:

   Save the workbook on OneDrive, use Share button, and enable Track Changes -> Option B

4. Quick Check:

   Cloud + Share + Track Changes = collaborative tracking [OK]

Hint: Use cloud save + Share + Track Changes for teamwork [OK]

Common Mistakes:

• Sharing via email causes version conflicts
• Not using cloud storage limits collaboration
• Disabling Track Changes loses edit history