Sharing workbooks in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to save the workbook with sharing enabled.

Excel

ActiveWorkbook.SaveAs Filename:="SharedBook.xlsx", [1]:=True

Drag options to blanks, or click blank then click option'

AReadOnlyRecommended

BCreateBackup

CShareWB

DPassword

Attempts:

3 left

💡 Hint

Common Mistakes

Using ReadOnlyRecommended instead of ShareWB

Confusing password protection with sharing

Omitting the sharing parameter

The ShareWB parameter enables sharing when saving the workbook.

2fill in blank

medium

Complete the code to allow multiple users to edit the workbook simultaneously.

Excel

ActiveWorkbook.[1] = True

Drag options to blanks, or click blank then click option'

ATrackChanges

BEnableAutoSave

CAllowEditRanges

DMultiUserEditing

Attempts:

3 left

💡 Hint

Common Mistakes

Using KeepChangeHistory instead of MultiUserEditing

Confusing AllowEditRanges with multi-user editing

Trying to enable AutoSave for sharing

The MultiUserEditing property allows multiple users to edit the workbook at the same time.

3fill in blank

hard

Fix the error in the code to properly share the workbook.

Excel

ActiveWorkbook.[1] = True

Drag options to blanks, or click blank then click option'

AMultiUserEditing

BSharedWorkbook

CShareWorkbook

DSharing

Attempts:

3 left

💡 Hint

Common Mistakes

Using ShareWorkbook instead of MultiUserEditing

Trying to call Add on a non-collection property

Confusing method and property names

The correct property to enable sharing is MultiUserEditing, not a property named ShareWorkbook or similar.

4fill in blank

hard

Fill both blanks to create a shared workbook and enable change tracking.

Excel

ActiveWorkbook.[1] = True
ActiveWorkbook.[2] = 30

Drag options to blanks, or click blank then click option'

AMultiUserEditing

BKeepChangeHistory

CEnableSharing

DAllowEditRanges

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing AllowEditRanges with sharing

Using EnableSharing which is not a valid property

Setting KeepChangeHistory before enabling sharing

Setting MultiUserEditing to True enables sharing, and KeepChangeHistory to 30 enables tracking changes for 30 days.

5fill in blank

hard

Fill all three blanks to save a shared workbook with a password and enable change history.

Excel

ActiveWorkbook.SaveAs Filename:="SharedBook.xlsx", Password:="[1]", [2]:=True
ActiveWorkbook.[3] = 30

Drag options to blanks, or click blank then click option'

Asecret123

BShareWB

CKeepChangeHistory

DReadOnlyRecommended

Attempts:

3 left

💡 Hint

Common Mistakes

Using ReadOnlyRecommended instead of ShareWB

Omitting the password or using an empty string

Not enabling KeepChangeHistory for history

Use a password like secret123 to protect the file, set ShareWB to True to enable sharing, and KeepChangeHistory to 30 to keep change history for 30 days.

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