how to make an excel file shared in sharepoint

Unavailable change tracking: Excel Co-Authoring only allows you to track versions, so you won’t be able to go back to a specific edit.Here are the main Excel Co-Authoring limitations: However, if you use this feature as an alternative to a business automation tool, it will disappoint you. If you use Excel Co-Authoring for its main purpose - multiple user editing - you will be happy with what it offers.

Now that you know what Excel Co-Authoring is and what it can do for you, let’s see how it works. File format: Save Excel files as xlsx.Cloud storage: OneDrive, OneDrive for Business, or SharePoint Online to store the Excel file you will co-author.A “Share” button should appear on the top right. To check that your Excel version supports Co-Authoring, open an Excel spreadsheet. What do you need for Co-Authoring in Excel?īefore explaining how Excel Co-Authoring works, let’s make sure that your system fulfills these technical requirements: Now, let’s explore the key system requirements for you to get the most out of Excel Co-Authoring. A way to work around this is to keep the file open so that everyone can see the edits in real-time. As we further explain in the section on Excel Co-Authoring limitations, Co-Authoring doesn't allow you to track changes. Note that Microsoft recommends using Excel Co-Authoring instead of Shared Workbooks, given that the latter presents many limitations. Use mentions in comments to notify other users about important changes.AutoSave: Switch on “AutoSave” to make changes visible to everyone simultaneously.This can affect the proper functioning of the feature and cause the system to lock it. OneDrive or SharePoint: Avoid having users access the spreadsheet from different storage systems.To unlock the full potential of Excel Co-Authoring for team collaboration, we recommend also using the following tools or features when collaborating on spreadsheets: However, Co-Authoring in Excel means that multiple users in your organization can now open an Excel workbook without finding it locked because someone else was using it. Until now, Excel users have been able to collaborate on shared workbooks, which was already a move forward in productivity and efficiency. Excel Co-Authoring is the most recent solution offered by Microsoft Excel for online collaboration.

How to make an excel file shared in sharepoint