- What is Excel Co-Authoring?
- What do you need for Co-Authoring in Excel?
- How does Co-Authoring in Excel Work?
- How to open a workbook for Excel Co-Authoring in SharePoint?
- Excel Co-Authoring limitations
- How to improve Google Sheets collaboration?
- Collaborating on Excel with Layer
Nowadays, the most common scenario for any business working with Excel is to have more than one user working on the same spreadsheet. This is essentially what we know as team collaboration.
As with other Microsoft tools, Excel offers various features that can adapt to our working style. If you need to work on large datasets with other users, the Excel Co-Authoring feature will be of great help, since it allows users to collaborate on the same Excel file simultaneously.
This complete guide will show you how to get the best results for your team with Excel Co-Authoring features. First, we’ll explain what it is and the system requirements. Then, we’ll explore how it contributes to team collaboration. Finally, you’ll learn step-by-step how to use the Co-Authoring feature, including working around its limitations.
What is Excel Co-Authoring?
Excel Co-Authoring is the most recent solution offered by Microsoft Excel for online collaboration. Until now, Excel users have been able to collaborate on shared workbooks, which was already a move forward in productivity and efficiency. 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.
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:
- OneDrive or SharePoint: Avoid having users access the spreadsheet from different storage systems. This can affect the proper functioning of the feature and cause the system to lock it.
- AutoSave: Switch on “AutoSave” to make changes visible to everyone simultaneously.
- @mentions: Use “@” mentions in comments to notify other users about important changes.
Note that Microsoft recommends using Excel Co-Authoring instead of Shared Workbooks, given that the latter presents many limitations. As we further explain in the section on Excel Co-Authoring limitations, Co-Authoring doesn't allow you to track changes. A way to work around this is to keep the file open so that everyone can see the edits in real-time.
Now, let’s explore the key system requirements for you to get the most out of Excel Co-Authoring.
What do you need for Co-Authoring in Excel?
Before explaining how Excel Co-Authoring works, let’s make sure that your system fulfills these technical requirements:
- Microsoft Version: Office 365. To check that your Excel version supports Co-Authoring, open an Excel spreadsheet. A “Share” button should appear on the top right.
- Cloud storage: OneDrive, OneDrive for Business, or SharePoint Online to store the Excel file you will co-author.
- File format: Save Excel files as xlsx, .xlsm, or .xlsb.
Now that you know what Excel Co-Authoring is and what it can do for you, let’s see how it works.
How to Share an Excel File for Multiple Users?
There are different ways to share an Excel file. Here's how to share an Excel file with multiple users for easy collaborationREAD MORE
How does Co-Authoring in Excel Work?
For the Co-Authoring feature to work in your Excel spreadsheet, save it to OneDrive or SharePoint, as we previously mentioned. Let’s see how to share your workbook with other users in OneDrive.
How to share a workbook for Excel Co-Authoring in OneDrive?
Although you can use the Excel Co-Authoring without OneDrive, you will need to store the spreadsheet on a cloud supported by Microsoft; another option is OneDrive for Business or SharePoint.
- 1. Open an Excel workbook and click on the “Share” button to the far right of your screen.
- 2. To upload your workbook, select any of the available shared folders. You will usually have the standard OneDrive and OneDrive for Business. If you choose the OneDrive account you are logged into, Excel will directly prompt you to save it. Once you enter a name, click “OK”.
Please note: Excel gives you the option of sending it as an attachment in Excel or PDF format.
- 3. Before entering the name/email of the user(s) you want to share the workbook with, check the access permissions. Excel will set it to “Anyone with the link can edit” by default.
- 4. If you saved successfully, you should now see the “AutoSave” button is activated, and the “Saved” status is at the top.
OneDrive, OneDrive for Business, and SharePoint are available to users who have a Microsoft Office 365 subscription. Although both can function as a cloud storage system, SharePoint offers other features for collaboration, including CMS (Content Management System) and dashboards.
How to open a workbook for Excel Co-Authoring in SharePoint?
As soon as you upload an Excel workbook to OneDrive, it will be accessible via Sharepoint. This is how you can open a file for Excel Co-Authoring in SharePoint.
- 1. Open Microsoft Office 365 application.
- 2. Select the “SharePoint” icon on the left side, where all Microsoft Office 365 apps are located.
- 3. Click on “My files” - the last icon on the left menu.
- 4. Click any file that you would like to co-author. As you can see below, the file we uploaded to OneDrive for Business now appears in “Recent”.
- 5. Check how SharePoint appears in the file path in the browser.
Now that you’ve seen how easy it is to make your Excel workbook available online for Co-Authoring, we’ll go over some of its limitations and offer solutions to work around them.
Discover what Excel version control is, the version control features Excel has to offer, and how to use them to share, merge, and review Excel changesREAD MORE
Excel Co-Authoring limitations
If you use Excel Co-Authoring for its main purpose - multiple user editing - you will be happy with what it offers. However, if you use this feature as an alternative to a business automation tool, it will disappoint you. Here are the main Excel Co-Authoring limitations:
- 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.
- Overlooked comments: Unless you provide clear instructions on how to add comments and notes in Excel, they can quickly become chats for your team. This can have a noticeable effect if you overlook an important comment related to missing data or errors.
- Number of co-authors: Microsoft recommends keeping the number of co-authors to class-size or even lower to avoid any delays or malfunctions.
- Broken cell references: Having several users working simultaneously can lead to accidental cell or formula changes.
- Cloud-restricted: If you want to use the Excel Co-Authoring feature, you can only do so online. Unlike other Microsoft Office tools, this does not offer an offline version.
- Filtering: Although filtering options, including sorting and viewing, are available, it will affect all users working on the file.
While Excel Co-Authoring is useful for teams that want to work on spreadsheets simultaneously, it is usually the case that online collaboration will require more advanced features to level up to their business workflow. Layer offers a space for collaboration and an excellent way for your team to manage data while still benefiting from the same Co-Authoring and collaboration features.
How to improve Google Sheets collaboration?
Layer is an add-on that equips finance teams with the tools to increase efficiency and data quality in their FP&A processes on top of Google Sheets. Share parts of your Google Sheets, monitor, review and approve changes, and sync data from different sources – all within seconds.
Using Layer, you can:
- Share & Collaborate: Automate your data collection and validation through user controls.
- Automate & Schedule: Schedule recurring data collection and distribution tasks.
- Integrate & Sync: Connect to your tech stack and sync all your data in one place.
- Visualize & Report: Generate and share reports with real-time data and actionable decisions.
Limited Time Offer: Sign up today and get free access to Layer, including all the paid features, so you can start managing, automating, and scaling your FP&A processes on top of Google Sheets!
Collaborating on Excel with Layer
There are many benefits to using Layer to help you work around Excel’s Co-authoring limitations:
- Available change tracking: Easily track changes in Excel and select which ones to merge or discard.
- Number of co-authors and secure references: Since you can share separate sheets or cell ranges without the need to share your whole spreadsheet, you have more control over your data and user permissions.
- Avoid troubleshooting: Managing your own communication flows while keeping track of all changes helps you avoid encountering issues such as a locked spreadsheet you can no longer access.
- No need for comments: Layer handles all changes and merging of data automatically, so there is no need to rely on comments from each user. You can also communicate with your collaborators and exchange feedback or context, all in one place.
Excel’s Co-Authoring feature has become a huge way for Excel users to collaborate effectively on their projects. However, it’s important to understand exactly how this feature works and its limitations to use it optimally when managing your spreadsheet data.
This complete guide has shown you how to achieve the full potential of Excel Co-Authoring as a tool for multiple editing. You should now know what Excel Co-Authoring is and whether it’s compatible with your system and business process or not. Overall, it can contribute to team collaboration, as long as we consider its limitations. Finally, you should know how to use the Co-Authoring feature and work around its limitations.
If you found this complete guide useful, you may also be interested in reading our blog article on how to share an Excel file.