Sharing workbooks in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does sharing a workbook in Excel allow you to do?

Sharing a workbook lets multiple people open and edit the same Excel file at the same time, making teamwork easier.

beginner

How do you enable workbook sharing in Excel?

Go to the Review tab, then click on 'Share Workbook' and check 'Allow changes by more than one user at the same time'.

intermediate

What happens if two people change the same cell in a shared workbook?

Excel will ask which change to keep when you save, so you can choose the correct version.

intermediate

Can you use all Excel features in a shared workbook?

No, some features like creating tables or conditional formatting are limited or disabled in shared workbooks.

advanced

What is the modern alternative to sharing workbooks in Excel?

Using OneDrive or SharePoint to save the file and co-authoring it online allows real-time collaboration without many sharing limits.

Where do you find the option to share a workbook in Excel?

A Insert tab

B Home tab

C Review tab

D Data tab

The 'Share Workbook' option is located under the Review tab in Excel.

What does Excel do when two users edit the same cell in a shared workbook?

A Prompts user to choose which change to keep

B Keeps the first change only

C Deletes both changes

D Automatically merges changes

Excel prompts the user to choose which change to keep to avoid data loss.

Which feature is NOT available in a shared workbook?

A Using formulas

B Sorting data

C Entering data

D Creating tables

Creating tables is disabled in shared workbooks to avoid conflicts.

What is a benefit of using OneDrive for Excel files?

A Files cannot be edited

B Real-time co-authoring with others

C Only one person can open the file

D No internet connection needed

OneDrive allows multiple users to edit Excel files at the same time with real-time updates.

What must you do before sharing a workbook for editing?

A Enable sharing in workbook settings

B Save the workbook as PDF

C Close the workbook

D Delete all formulas

You must enable sharing in the workbook settings to allow multiple users to edit.

Explain how to share a workbook in Excel and what users should expect when editing together.

Think about the steps and what happens during editing.

Describe the limitations of using shared workbooks and the modern alternatives.

Consider what features are limited and how cloud saves help.

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