How to Share Excel File for Multiple Users

For working together in a team or organization, you might often need to share an Excel file. So that all of you can edit the workbook at the same time. In this instructive session, I’ll discuss how you can share the Excel file for multiple users to do real-time collaboration.


Download Practice Workbook


2 Methods to Share Excel File for Multiple Users

Let’s say you have an Excel file namely Sales Report of Frutis.xlsx and you need to share the file for multiple users.

Dataset

There are mainly two methods for sharing Excel file for multiple users varying in the Excel version.


1. Share Excel File for Multiple Users in Microsoft 365

If you’re a Microsoft 365 and Excel 2021 user, you can use the dynamic Co-authoring feature to share the file with multiple users. You can do it either using OneDrive or sending the file directly.


1.1. Share Excel File in Microsoft 365 Using OneDrive

If you upload your Excel file to OneDrive and then share it with users, you’ll get a lot of outstanding features that I’ll discuss later portion. Please do the following steps.

Step 01: Pick Share Button

  • Firstly, go to File > Share.

Choosing Share Button

  • Alternatively, you can pick the Share button located in the upper-right corner of your spreadsheet.

Choosing Share Button

Step 02: Upload Excel File to One Drive

  • Next, choose the OneDrive account.

How to Share Excel File for Multiple Users Sharing Excel File in Microsoft 365 Version

Then, you’ll see the following message.

Uploading OneDrive

Step 03: Share File to User

Finally, you’ll get the following sharing option within a few moments.

  • So, input the user name, group, or email of users. And, click on the Send button.

How to Share Excel File for Multiple Users Sharing Excel File in Microsoft 365 Version

After sending you’ll get the confirmation message and users will get the message about your file.

Confirmation Message


1.2. Share Excel File in Microsoft 365 without OneDrive

What if you want to share your Excel file to users simply instead of uploading it on OneDrive?

  • After picking the Share button, just select the Excel Workbook to share the .xlsx format or PDF icon to convert the file into PDF format (especially in the case of printing).

How to Share Excel File for Multiple Users Sharing Excel File in Microsoft 365 Version

  • So, type the email address of the user and click on the Send button.

How to Share Excel File for Multiple Users Sharing Excel File in Microsoft 365 Version

Read More: How to Share Excel File Online (2 Easy Methods)


Similar Readings


2. Share Excel File for Multiple Users in Earlier Versions

Tracking changes is a unique feature in the earlier version. In the case of using those versions or exploring the feature only, you may follow the below steps.

Step 01: Adding Command

You’ll get the commands related to sharing the workbook by default (just go to Review tab > Changes ribbon).

Also, you can add those commands if you’re using the updated version.

  • Initially, right-click on any blank space within the ribbon and pick the Customize the Ribbon option.

Adding Necessary Commands

  • In the Excel Options, navigate to Customize Ribbon option.

Now, you need to add the following commands.

  1. Share Workbook (Legacy)
  2. Track Change (Legacy)
  3. Protect Sharing (Legacy)
  4. Compare and Merge Workbooks
  • So, keeping the Choose command from as All Commands pick the Share Workbook (Legacy) first and click on the Add button.

Adding Necessary Commands

Note: Here, I created a dedicated tab and group. It’s a quite simple task. Just, utilize the New Tab and New Group options.

  • After adding those commands, the output will be as follows. And, press OK.

Adding Necessary Commands

Step 02: Go to Trust Center

Sometimes, sharing a workbook might not work properly. As a precautionary step, do the below task.

  • Just, go to Trust Center in the Excel Options and click over the Trust Center Settings.

Trust Center Settings

  • Later, uncheck the box before the Remove personal information from file properties on save option and press OK.

Trust Center Settings

Step 03: Share Workbook

Lastly, choose the Share Workbook (Legacy) command from the Share tab and check the box in the Editing tab as shown below.

How to Share Excel File for Multiple Users in Earlier Excel Versions

After pressing OK, you’ll get the following message. So, press OK.

Earlier Excel Versions

Now, your Excel file is ready to share as you see the Shared word after the file name. So, share the file online or offline.

How to Share Excel File for Multiple Users in Earlier Excel Versions

Furthermore, you can protect your Excel file and then share for multiple users if necessary.

Read More: How to Enable Share Workbook in Excel


How to Utilize Co-authoring Feature

In this section, I’ll highlight some fruitful things about the most updated file-sharing system i.e. Co-authoring feature provided by Microsoft 365.


Share File Link Only

  • If you want to inform users about your shared file link using other platforms, just press the Copy button.

Copy the Link Only Using Co-authoring Feature

  • Now copy the link and paste it where you want.

How to Share Excel File for Multiple Users Share File with Specific User Using Co-authoring Feature


Share Excel File with Specific User Only

By default, anyone can open the link. But when you need to share with specific users, you can do that.

  • Select the Anyone with the link can edit.

Share File with Specific User Using Co-authoring Feature

  • In the Link settings, navigate to the Specific people option and press the Apply button.

How to Share Excel File for Multiple Users Share File with Specific User Using Co-authoring Feature


Share an Excel File for Multiple Users with Password

Moreover, you can assign a password to open the shared file.

  • Click on the Set Password option.

Share File with Passward Using Co-authoring Feature

  • Next, input your password and press the Apply button.

Share File with Passward Using Co-authoring Feature


Restrict File Sharing

Sometimes, you may have to share the Excel file without providing the Editing permission. That means users only can view the file.

  • For doing this, just uncheck the box before Allow editing option.

Put Restriction in Co-authoring Feature

Read More: [Solved]: Share Workbook Not Showing in Excel (with Easy Steps)


How to Track Changes in a Shared Excel File

In the case of old versions, you can track the changes that users make.

  • Click over the Track Changes (Legacy) command and choose the Highlight Changes option.

How to Track Changes

  • Check the box before When and Who. And, press OK.

How to Track Changes

Now, if any user makes any change, you’ll see the cell as highlighted and the changed thing will pop up with the date-time.

How to Share Excel File for Multiple Users How to Track Changes


How to Compare and Merge Workbook

After collecting the shared file, you have to update the workbook.

  • Navigate to the Compare and Merge Workbooks command.

How to Compare and Merge Workbooks

  • Now, select the multiple files by pressing the SHIFT key and pressing OK.

How to Share Excel File for Multiple Users How to Compare and Merge Workbooks

Note: You have to keep your file and other shared file in the same folder. No matter what is the file name.


How to Stop Sharing or Remove User

This is a bonus section for you, if you want to stop sharing or remove users you can follow these steps.


Stop Sharing in Microsoft 365

If you want to stop sharing the Excel file, do the following tasks.

  • Press over the icon after the Shared with option.

How to Stop Sharing

  • Then, click over Stop sharing.

How to Stop Sharing


Remove User in Earlier Versions

  • In the case of the earlier version, go to the Share Workbook (Legacy) command first in the Editing tab.
  • Then, select a user and press the Remove User button.

How to Remove User

Read More: How to See Who Is in a Shared Excel File (With Quick Steps)


Things to Remember

⧬ You’re not able to use Co-authoring and tracking changes methods simultaneously as the Track Changes is a legacy command

⧬ Though you cannot track the changes while using Co-authoring method, it is a simple, easier, and also time-saving method.


Conclusion

That’s the end of today’s session. I hope this article would be highly beneficial for you to share Excel file for multiple users. Anyway, don’t forget to share your thoughts.


Related Articles

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo