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.