Share your Excel workbook with others

Sharing an Excel workbook with others is a great way to collaborate and ensure that multiple people can view or edit the same document. There are several ways to share an Excel workbook depending on how you want to collaborate, whether you’re sharing a local file or using cloud-based solutions like OneDrive or SharePoint.

1. Share Excel Workbook via Email

One of the simplest methods for sharing your Excel workbook is to send it as an email attachment.

Steps:

1. Save Your Workbook: Ensure your workbook is saved and closed before attaching it to an email.
2. Open Your Email Client: Open your email application (e.g., Outlook, Gmail).
3. Attach the Workbook:
   • In your email, click the attachment icon and select the Excel workbook file from your computer.
4. Send the Email: Add the recipient’s email address and send the email.

2. Share Excel Workbook via OneDrive or SharePoint (Cloud Sharing)

If you’re using a Microsoft 365 subscription or have OneDrive or SharePoint, you can save your Excel workbook to the cloud and share it for real-time collaboration.

Steps to Share via OneDrive or SharePoint:

1. Save to OneDrive/SharePoint:
   • First, save your workbook to OneDrive or SharePoint.
   • Go to the File tab > Save As, and choose either OneDrive or SharePoint as the save location.
2. Share the Workbook:
   • Click the Share button on the top-right corner of the Excel window.
   • If you’re using OneDrive, you’ll see options to share the file via a link or by email.
   • Choose Anyone with the link can edit if you want others to make changes, or Anyone with the link can view for read-only access.
3. Send the Link:
   • Enter the email addresses of the people you want to share the workbook with, or copy the link and send it through other means (like chat, messaging apps, etc.).
4. Collaborate in Real-Time: Once shared, recipients can open the workbook in Excel or Excel Online and collaborate with you in real time.

3. Share Excel Workbook via Google Drive

If you don’t use OneDrive or SharePoint, you can upload your Excel workbook to Google Drive and share it using Google’s collaboration tools.

Steps to Share via Google Drive:

1. Upload the Excel Workbook to Google Drive:
   • Open Google Drive in your browser.
   • Click on the New button, and select File Upload.
   • Choose your Excel file and wait for it to upload.
2. Share the Workbook:
   • Once the file is uploaded, right-click on the file and select Get link.
   • In the sharing settings, choose the access level (e.g., Viewer, Commenter, Editor).
   • Click Copy link to share the link with others.
3. Edit or View the File:
   • You can also open the Excel file in Google Sheets to collaborate with others directly in Google’s online platform.

4. Share Excel Workbook Using SharePoint

If you are using SharePoint, you can store and share your workbook similarly to OneDrive.

Steps to Share via SharePoint:

1. Upload Your Workbook to SharePoint:
   • Go to your SharePoint site.
   • Upload your workbook to a document library in SharePoint.
2. Share the Workbook:
   • Once the file is uploaded, select it and click on the Share button.
   • Choose Copy Link or send via email.
   • You can also set permissions for editing or viewing access.
3. Collaborate: SharePoint allows for real-time collaboration, just like OneDrive.

5. Share Excel Workbook for Viewing or Editing with Password Protection

If you need to share the workbook and ensure security, you can set a password for opening or editing the file.

Steps to Password-Protect a Workbook:

1. Open the Workbook: Open the Excel workbook you want to share.
2. Set Password Protection:
   • Go to the File tab and click on Info.
   • Select Protect Workbook, then choose Encrypt with Password.
   • Set a password for opening or editing the workbook.
3. Send the File: Share the file as usual via email, cloud sharing, or any other method. Make sure to send the password securely (e.g., via phone or encrypted messaging).

6. Share Excel Workbook with Review and Comments

If you want others to review or comment on your workbook without making changes to the content, you can use Track Changes or Comments.

Steps to Share for Review:

1. Go to the Review Tab:
   • Click the Review tab on the Ribbon.
2. Share for Review:
   • Select Share Workbook or New Comment.
   • In the Share Workbook option, choose Allow changes by more than one user at the same time.
   • You can also add comments directly in cells or use the Comments feature to make suggestions.
3. Send the Workbook: Once the review features are activated, share the workbook via email or cloud.

7. Track Changes and Comments in Shared Workbooks

If you want to track who made changes to the workbook, Excel has a Track Changes feature.

Steps for Track Changes:

1. Enable Track Changes:
   • Go to the Review tab.
   • Click Track Changes and select Highlight Changes.
2. Share the Workbook: Once track changes are enabled, share the workbook via email or cloud. Excel will track all changes made by users and highlight them in the document.
3. Review Changes: You can review changes by going to the Review tab and clicking Accept or Reject Changes.

Conclusion

There are various ways to share your Excel workbook with others depending on your needs and collaboration preferences. Whether you’re sending it via email, sharing it through cloud services like OneDrive or Google Drive, or allowing others to edit it in real time using SharePoint or Excel Online, these methods provide flexibility and ease of sharing. You can also secure your workbook with passwords, enable tracking, or use comments for reviewing purposes.