Sign Up for OneDrive
If you use Microsoft Office, you may have an active OneDrive account. If not, or if you’re unsure, sign up for OneDrive before continuing. The only exception is if you intend to share an Excel file hosted on a SharePoint Online library or internal network, in which case, you don’t need a OneDrive account.
How to Share an Excel File in Microsoft 365 or Excel 2019
To share an Excel workbook:
How to Share a File in Excel Online
Just like Excel for Microsoft 365 and Excel 2019, the web-based version of Excel uses the co-authoring features in place of what used to be known as Shared Workbooks.
How to Share a File in Excel 2016
Follow the Microsoft 365 instructions, as the co-authoring feature and the steps are similar. The main difference is the Share button, which appears in the upper-right corner and is represented by a head and torso alongside the word Share. If you’d like, you can use the Shared Workbook feature. To do so, add the appropriate options to the Quick Access Toolbar by following the steps below.
Add a Shared Workbook Button in macOS
To add the Shared Workbook functionality in macOS:
Add a Shared Workbook Button in Windows
Follow these steps to add the Shared Workbook functionality to Excel 2016 for Windows:
