Share An Excel Workbook

Publication Date :

Blog Author :

Edited by :

Download FREE Share An Excel Workbook Excel Template and Follow Along!
Share An Excel Workbook Excel Template.xlsx

Table Of Contents

arrow

What Is Share An Excel Workbook?

Share an Excel Workbook, as the name suggests, helps multiple users work at the same time on one shared worksheet. We can enable the shared option in Excel so that many users with access can simultaneously.

For example, to share an Excel workbook with other users, we need to save it to a local network location where others can access it and make changes. We also can keep track of those changes and can accept or reject those changes as per the requirement. Using the "Review" tab, we can share the workbook, as shown below.

Share Excel Workbook - Intro

Key Takeaways

  • The Share an Excel Workbook is an effective way to work simultaneously on a single workbook, by different users, from different machines, places, etc.
  • It avoids saving multiple worksheets data, and then merging them, which in turn, saves time.
  • We must ensure to protect the workbook, using a password, so that the admin can have complete control to track the changes by users, which helps reduce errors.
  • We can have control to add or remove users or accept or reject changes at any given time using the shared workbook.

How To Share An Excel Workbook?

Let’s take the below example to understand how to share an Excel sheet.

We have given the below customer details in a workbook saved with “Customer Data.”

Excel Share File Example 1

The steps for sharing an Excel workbook in excel are,

  1. First, go to the REVIEW tab, and click the “Share Workbook” option under “Changes”. You may refer to the below screenshot.

    Excel Share File Example 1-1

  2. Then, an Excel “Share Workbook” File dialog box will appear. See the below screenshot.


    Excel Share File Example 1-2

  3. Under the Editing tab, tick the checkbox, and click OK.


    Excel Share File Example 1-3

  4. By clicking on this checkbox, we are giving access to other users for editing.

  5. The screen above shows the one who has the workbook open.

  6. After clicking “OK”, one dialog box will appear with a message. For example, refer to the below screenshot.

    Excel Share File Example 1-4

  7. Click OK, and finally, save the workbook.

Highlight The Changes Done On Excel By Other Users

We can also highlight the changes which other users have made.

The steps to highlight the changes to keep track of the work are,

  • Step 1: Go to the REVIEW tab, and click the Track Changes option in Excel under the Changes section, as shown below.
Highlight the Changes step 1
  • Step 2: When we click the “Track Changes” drop-down option, we get options, as shown below. Click on “Highlight Changes…”.
Highlight the Changes step 1-1
  • Step 3: The “Highlight Changes” dialog box opens. Here, click OK, as shown below.
Highlight the Changes step 1-2
  • Step 4: Now, click the “Protect Shared Workbook” option under the “Changes” section, as shown below.
Highlight the Changes step 1-3
  • Step 5: It will open a dialog box. Tick on the checkbox, and click OK, as shown in the below screenshot.
Highlight the Changes step 1-4
  • Step 6: Now, Excel will show the changes done by the users. The sheet automatically highlights the changes wherever we do, as shown in the screenshot below.
Highlight the Changes step 1-5

How To Accept/Reject The Changes Done By Other Users?

The steps to accept/reject the changes done by other users if those changes are not according to our requirements are,

  • Step 1: Go to the REVIEW tab, click on the Track Changes in excel under the Changes section, and select the Accept/Reject Changes option from the list, as shown below.
Accept-Reject the Changes step 1
  • Step 2: A dialog box will appear, click OK, as shown in the below screenshot.
Accept-Reject the Changes step 1-1
  • Step 3: Then, another dialog box will appear. It will show you all the changes one by one, as shown below. It will also highlight the cell in the spreadsheet where the changes are made.
Accept-Reject the Changes step 1-2
  • Step 4: Click the Accept button to accept the changes or the Reject button to reject the changes.

Important Things To Note

  • After sharing the workbook, when one or more users edit the same workbook simultaneously, some edits can affect the same cells too.
  • If we have left the worksheet untouched for a while, maybe an hour or so, first refresh it or wait till it gets refreshed on its own, so we do not miss the saved changes, or overwrite anything.

Frequently Asked Questions (FAQs)

1

How to resolve saving Conflicts in an Excel shared workbook?

Arrow down filled
2

How to stop sharing or remove users with permission to work from Shared Workbooks?

Arrow down filled
3

What are some limitations of the Excel shared workbook file?

Arrow down filled
4

How can we protect a shared workbook?

Arrow down filled