How to Share Excel File Online (2 Easy Methods)

We often need to Share Excel files Online. In this article, we will show you 2 quick methods of how to Share Excel file Online. To demonstrate our methods we’ve selected a dataset that represents cars owned by employees with 3 columns:Name”. “Model”, “Company”.


Download Practice Workbook


2 Ways to Share Excel File Online

1. Using Ribbon to Share Excel File Online

For the first method, we’re going to use the Share feature from the Ribbon to Share Excel files.

Steps: 

  • Firstly, select Share from the Ribbon.

Alternatively, we can do this from File >>> Share.

Using Ribbon to Share Excel File Online

This will bring the Share dialog box.

  • Secondly, select OneDrive.

Here, you can choose to send the file via email directly from the option “Apply a copy instead” below.

Then, if not already logged in, you need to log in to your account.

After that, another dialog box will appear.

Using Ribbon to Share Excel File Online

Another dialog box saying “our link is copied to the clipboard” will appear.

Moreover, by clicking on “Anyone with the link can edit >“ we can bring more options.

  • Then, we can add a password and expiration date to our file.
  • Finally, press Apply.

Option Settings: Using Ribbon to Share Excel File Online

Finally, If specific people are not defined, then we can share this link using social networks, Email, and other means.

Thus, we’ve shared our Excel file Online.

Read More: How to Enable Share Workbook in Excel


Similar Readings


2. Share Excel File Online Using Cloud Drive & Enabling Track Changes

For the last method, we’re going to track changes and Share the Excel file Online using Google Drive. We’ll use Legacy Features to enable track changes here.

Steps:

We’re going to customize the Ribbon here.

  • Firstly, press ALT, F, then O to bring up the Excel Options window.
  • Secondly, from Customize Ribbon, then under the Review tab select New Group.

Share Excel File Online Using Cloud Drive & Enabling Track Changes

  • Thirdly, Right-Click on it and Rename it to “Track(Legacy)”.
  • Then, press OK.

Now we’ll add Commands to our created sub-tab.

  • Firstly, keep the selection on “Track (Legacy) (Custom)”.
  • Secondly, select All Commands in the “Choose commands from:dropdown box.
  • Thirdly,  scroll down to find “Compare and Merge Workbooks…” and select it.
  • Then, press Add.

Share Excel File Online Using Cloud Drive & Enabling Track Changes

  • Similarly, we’ll add these three more Commands
    • Protect Sharing (Legacy).
    • Share Workbook (Legacy).
    • Track Changes (Legacy).
  • Finally, press OK.

Here, we’ll track changes in our file.

  • Firstly, from the Review tab >>> Track Changes (Legacy) >>> select “Highlight Changes…”.

Share Excel File Online Using Cloud Drive & Enabling Track Changes

A dialog box will appear.

  • Secondly, select “Track changes while editing. This also shares your workbook.
  • Thirdly, from “Highlight which changes” select –
    • When: All.
    • Who: Everyone.
  • After that, press OK.

Moreover, we can add protection to our dataset.

  • From the Review tab >>> select Protect Shared Workbook (Legacy).

Another dialog box will appear.

  • Select, Sharing with track changes.

This will keep the changes history in the file.

  • Press OK.

Share Excel File Online Using Cloud Drive & Enabling Track Changes

Thus, we’ve prepared our Workbook to keep track of the changes. Then, we’re going to share this file via Google Drive.

  • Firstly, go to the Google Drive website.
  • Secondly, drag the file into the desired location inside our drive.

  • Thirdly, Right Click on the file and click on Share.

Google Drive Share: Share Excel File Online Using Cloud Drive & Enabling Track Changes

  • Then, we can add people using an Email ID.
  • Or, we can choose to share it with everyone with the link.

  • After that, press Done.

This link will open the file inside Google Sheets. This file needs to be downloaded and edited using Excel. Else, some features will be dropped from the file. Therefore, to avoid this issue, we can use OneDrive.

Google Sheets Warning: Share Excel File Online Using Cloud Drive & Enabling Track Changes

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


Things to Remember

  • If the Workbook contains tables then our Track Changes will not work. We need to convert all tables into a range.
  • If you upload to Google Drive, then the intended person should download the file and edit it with Excel. Else, it will lose some features.
  • We’re using Office 365, depending on your version, some options may not be available.
  • You will not be able to Track Changes and Co-Authoring at the same time.

Conclusion

We’ve shown you 2 easy methods of how to Share Excel file Online. If you face any problems, feel free to comment below. Thanks for reading, keep excelling!


Related Articles

Rafiul Haq

Rafiul Haq

Hello! This is Rafiul. I have an engineering degree and an MBA (finance) degree. I am passionate about all things related to data, and MS Excel is my favorite application. I want to make people's lives easier by writing easy-to-follow and in-depth Excel and finance related guides here at ExcelDemy.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo