Email systems have to contend with storing multiple copies of the same document, not to mention increased network traffic as documents are sent repeatedly. To use the co-authoring feature, every person who is sharing the file must have a version of Excel that supports co-authoring. Co authoring is hard to get working. On the other hand, it doesn’t offer a version history like Google Sheets does. If you still encounter co-authoring issues using Excel, assure you run the latest and greatest version of the Office suite. Make sure your file is saved in the right format: 1. for Excel spreadsheets use .xlsx, .xlsm or .xlsb 2. for Word documents use .docx, .doc or .docm 3. for PowerPoint presentations use .pptx, .ppt or .pps The co-authoring experience may be slightly different for files in different formats but overall you will be able to collaborate if using one of the formats mentioned above. However, everyone will need a version of the Excel app that supports co-authoring. What do I need to do to be able to have two users editing a spreadsheet in the desktop version of Excel at the same time? Locally synced Office files (such as Word documents, Excel spreadsheets, and PowerPoint presentations) that are synced by OneDrive for Business (Groove.exe) will no longer allow coauthoring between multiple users. If you are not sure if your site is an On-Premises site or not, ask the person in charge of your site, or your IT department. And each person’s selections appear in a different color so you can identify them easily. Yes, co-authoring support is now live for Excel on Windows desktop PCs, or at least it is for testers only at the moment […] That means you're not running the Click To Run version of Office, i.e. Real-time co-authoring is supported on Word for Windows Desktop 2016, and Word, PowerPoint, and Excel Online. Best Regards, Lisa Chen “The goal of the collaboration work we did in Excel Web App was to remove the “locked file” experience from users’ workflow in collaborative scenarios and enable interesting new ways for people to work together … As of today, this should be supported, but with several important limitations (credits to Serge Tremblay):. Co-authoring can be interrupted if someone uses a feature that is not fully supported in co-authoring. Unfortunately, not all versions of Excel support this feature. That has been addressed by Microsoft as of August 2017. Following on from my post about co-authoring in Word 2010, Joseph from Microsoft recently published the Excel equivalent: Collaborative Editing Using Excel Web App. All users who have edited the document, however, are … And with certain versions of Excel, you’ll see other people’s selections in different colors. Co-authoring allows you to collaborate in real time, where you can see everyone who is editing the workbook and the areas of the workbook they are working on. Co-authoring doesn’t provide the ability to track changes. When a document is checked out of a document library, the document is locked. Co-authoring in Excel on Windows desktops allows you to see where others are editing at the same time as you in a spreadsheet. The excel file has been shared with the members of the team. Newer versions of Excel no longer support the document sharing option I have written in one of the earlier texts. What co-authoring does. When you co-author, you can see each other’s changes quickly — in a matter of seconds. Co-authoring works well with PowerPoint. Excel Co-Authoring Issue - Changes can't be merged . It was held back from Semi-Annual for nearly a year. A great feature with an unexpected side-effect If you are on Office 365 and have access to either OneDrive for Business or Sharepoint a new feature will come available soon (and already is available to everyone on Office insider).This feature is called Co-authoring. Excel 2016 supports co-authoring but only with O365, not on-premises. Please remember to mark Ivan's reply as an answer if it helps. Excel 2016 supports co-authoring but only with O365, not on-premises. The Excel client application does not support co-authoring workbooks in SharePoint Server. The Excel mobile apps and the latest version of Excel for Office 365 also support co-authoring. A co-authoring friendly document Co-authoring is only supported on modern file formats including: .docx (Word), .pptx (PowerPoint), and .xlsx (Excel). In most versions of Excel—including Office 365, for the Web, and for mobile—you see your co-authors’ selections in real-time. The Excel client application uses the Shared Workbook feature to support non-real-time co-authoring workbooks that are stored locally or on network (UNC) paths. However, everyone will need a version of the Excel app that supports co-authoring. Excel was late to the party for real time co authoring, so since you're running Office Pro your version doesn't support it. You need an Office 365 subscription. In addition, Excel for Microsoft 365 supports co-authoring when you have an Microsoft 365 subscription. Versions of Excel that support co-authoring: Excel for Microsoft 365* Microsoft Excel is … This forum is for general questions and feedback related to Microsoft Excel (all versions) as they pertain to the IT Pro community. It does not affect files that are opened directly from a SharePoint URL. We’re also working on co-authoring in Excel for the Mac—stay tuned for more! Co-authoring allows you to collaborate in real time, where you can see everyone who is editing the workbook and the areas of the workbook they are working on. A great feature with an unexpected side-effect If you are on Office 365 and have access to either OneDrive for Business or Sharepoint a new feature will come available soon (and already is available to everyone on Office insider).This feature is called Co-authoring. That has been addressed by Microsoft as of August 2017. Co-Authoring in Excel. Excel for Android, Excel for iOS, and Excel Mobile support co-authoring. There are currently 1 users browsing this thread. tries to open them. Excel co-authoring for Desktop versions of Excel was released relatively recently, in 2017.Related Article.For the very long time it was not supported. My IT Support advised that I can use co-authoring with others on the same version for files stored in Sharepoint or OneDrive but I can't make it work. “Microsoft Excel’s New Co-Authoring Feature. Coauthoring allows you to edit a workbook hosted in the cloud (that is, OneDrive, OneDrive for Business, or SharePoint Online) simultaneously with other users. A co-authoring … This can stop the co-authoring process temporarily. Kindly guide me. If you are talking about the real-time co-authoring, some versions of the Office applications may not be affected. Microsoft Excel is the most used tool for the professional. With co-authoring, you'll see the changes others make in real time, and each person's changes may be in a different color. You're trying to co-author an Excel workbook on a SharePoint On-Premises site. For more information on which versions support it, see Collaborate on Excel workbooks at the same time with co-authoring. Meanwhile, co-authoring is coming to Office 2016. This thread is locked. If you want to work on the file at the same time as other people, then make sure everyone uses a version of Excel that supports co-authoring. Co-authoring is already available in Excel Online, Excel on Android, Windows Mobile and iOS (for Office Insiders). Co-authoring appears to work good when in Excel online. Version history will at least capture the revisions autosaved. At this time, Excel for Android, Excel for iOS, Excel Mobile, and Excel 2016 for Microsoft 365 subscribers are the versions that currently support co-authoring. Remember to mark as Solved and give out rep. By snapfade in forum Excel Programming / VBA / Macros, By RayRay10k in forum Excel Formulas & Functions, By pcpitstop in forum Hello..Introduce yourself, Search Engine Friendly URLs by vBSEO 3.6.0 RC 1, Excel Co-Authoring - Client version - 2016, https://support.office.com/en-us/art...c-31b04aed68b3, Excel Version Problem - Office 365 (2016) vs. 2013, Pivot table portability between Excel Windows version 2007/2013 and Mac version 2011/2016, Hi - I love the new Version of Excel 2016. Co-authoring in Office 365. Yes, co-authoring support is now live for Excel on Windows desktop PCs, or at least it is for testers only at the moment (those on the fast ring of the Office Insiders program). Collaborate on Excel workbooks at the same time Excel only supports co-authoring from the web application. In other words, co-authoring in Excel native desktop app did not work before. Track changes in Word is one of the hottest features, but Microsoft has been struggling with providing an equivalent feature for Excel. Sharing is legacy 2013 and earlier. – co-authoring in Excel 2010 is ONLY for the Excel Web App, not for the Excel 2010 client itself. I agree with @Chris Webb, I expect it will be your version of Excel. The Excel versions that support Co-authoring are: - Excel for Office 365* - Excel for Office 365 for Mac* - Excel Online - Excel for Android - Excel for iOS - Excel Mobile Excel 2016 doesn't support co-authoring i'm afraid. However, co-authoring doesn't track the changes, and you can't reject changes to revert to your original data. Files are all "locked for editing" when the second users Please remember to mark Ivan's reply as an answer if it helps. We are using SharePoint online. This is called co-authoring. Apps that support co-authoring Word and PowerPoint on all platforms, and on all versions since Office 2010, Excel Online, Android, and Windows Mobile. We’re also working on co-authoring in Excel for the Mac—stay tuned for more! As we saw earlier in the chart provided by Microsoft, the Excel client application does not support Co-Authoring, only through the Web App can we do this. ... To prevent flooding the DMS with versions, co-authoring checks in only the last version of the document. Office 365, which is causing your problems. When you co-author, multiple users can open and work on the same Excel workbook and see each other’s changes instantly. Co-Authoring in Excel. As Ivan said, Excel 2013 Co-Authoring works only in Excel Web App. As of today, this should be supported, but with several important limitations (credits to Serge Tremblay):. Ferdy Remember to mark as Solved and give out rep. One unsupported feature is change tracking. Did you begin by making the spreadsheet available for multiple simultaneous users? You need an Office 365 subscription. Co-authoring is Microsoft’s answer to Google Sheets and (at least officially) the replacement for shared workbooks. Microsoft had introduced a new co-authoring feature in Microsoft Excel for Windows that allows multiple users to work simultaneously on the same spreadsheet. It works with Microsoft Office 2010 and 2013. Whenever we attempt to get more than 1 person in the file, the additional authors receive a message that the file is locked for editing. Microsoft recommends that you use the co-authoring feature of Excel, which replaces Shared Workbooks. According to what I have been reading, the version we are running should support co-authoring in the windows client app, correct? Co-authoring doesn’t really make sense in some Excel files, so Excel offers limited co-authoring support. There are two ways of co-authoring in the Office applications. I think it's in the next release that comes out in January. PowerPoint. Co-authoring workbooks in SharePoint is supported by using the Excel Web App. They can co-author in Excel online (i.e., the browser version) but they cannot co-author in Excel desktop (the file will not open for them if I already have it open.) Not every application supports co-authoring. Whenever 1 user opens the sheet in the desktop app, it locks all other users from editing. The Excel mobile apps and the latest version of Excel for Microsoft 365 also support co-authoring. Co-authoring. This affects only locally synced files. It can still be used after manually adding to the quick menu or toolbar, but collaborating on documents has evolved into co-authoring. To specify a version retention limit, select Keep the following number of major versions and in the text box, type the number of versions. There are only certain types of documents that support co-authoring. Hi, I want co-authoring on Excel file in SharePoint 2010 and I checked that co-authoring is available on Word & PowerPoint 2010. In other words, co-authoring in Excel native desktop app did not work before. Microsoft had introduced a new co-authoring feature in Microsoft Excel for Windows that allows multiple users to work simultaneously on the same spreadsheet. with co-authoring. The Excel versions that support Co-authoring are: - Excel for Office 365* - Excel for Office 365 for Mac* - Excel Online - Excel for Android - Excel for iOS - Excel Mobile Excel 2016 doesn't support co-authoring i'm afraid. The track changes functionality of shared workbooks has so many limitations that it was officially stamped as “legacy” and replaced by the new co-authoring functionality. So is it possible co-authoring on Excel file and how to get it done? With each save, everyone editing the workbook at that time can see changes. Sharing an Excel Sheet to work together with team members is an amazing feature. You can follow the question or vote as helpful, but you cannot reply to this thread. 4. Mar 29, 2017 10:33:00 Office 365 Excel supports real-time collaboration with multiple people. Best Regards, Lisa Chen Thanks for your feedback, it helps us improve the site. In traditional collaboration, documents are shared via email attachments. It also depends on the app. Co-authoring, a feature that first appeared in the web-based Office applications, is finally available in Excel on Windows desktops. What co-authoring … Microsoft collaborates in real time in Office 365 version of Excel "Co-authoringFunction was announced.With this improvement, you can work on the same document as multiple people like Google Spreadsheet, and the change will be reflected in real time. It says so right on that page you linked to. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com. Co-authoring in Excel on Windows desktops allows you to see where others are editing at the same time as you in a spreadsheet. Compared with Google Sheets, Excel co-authoring has one advantage though: It also works with the locally installed versions of Excel on your desktop, not just with Excel online. Tracking versions and edits from multiple authors is difficult and time-consuming for users. Microsoft collaborates in real time in Office 365 version of Excel "Co-authoringFunction was announced.With this improvement, you can work on the same document as multiple people like Google Spreadsheet, and the change will be reflected in real time. The use of SharePoint to store documents for collaboration has reduced these problems by providing consistent access to up-to-date versions of documents, the ability to track earlier versions, … But works if everyone has the right version of excel or is accessing the file from a sharepoint web interface. The Good, The Bad & The Ugly” [Solution Saturday #7] Randy Austin April 21, 2019 No ... feature will not work with any older versions of Excel and I really do not believe they will adding this feature to support older versions. My IT Support advised that I can use co-authoring with others on the same version for files stored in Sharepoint or OneDrive but I can't make it work. You can use document co-authoring with Microsoft Word, PowerPoint, and OneNote. Does co-authoring have issues when authors are using different versions of Word? Co-authoring doesn’t really make sense in some Excel files, so Excel offers limited co-authoring support. How does co-authoring work with track changes? areas which enable co-authoring. Not all firms use Office 365, and users have found that the web versions of the Office applications offer limited capabilities compared to the desktop's rich functionality. If yes, any solutions other than using Word Online, which has some functionality limits. The Excel client application does not support co-authoring workbooks in SharePoint Server or SharePoint Online. With AutoSaveenabled, you can see everyone's changes to the workbook in real-time. As described in the following article, the co-authoring feature is not available for Semi-Annual Channel yet and there is no ETA about when the feature will be available in that channel. If you are not ready for others to see your changes, you can turn off AutoSave until you are ready to share your changes and receive others' changes. Microsoft has made its usual end of the month post concerning what’s new with Office 365, and the major fresh addition which has just happened for March is co-authoring support in Excel. This makes it unavailable for co-authoring. Co-authoring is already available in Excel Online, Excel on Android, Windows Mobile and iOS (for Office Insiders). Co-authoring in the desktop version of Excel I'm on Excel Version 1803 (Semi-annual Channel). • When you co-author, more than one person can open the file, and you can see each other's changes quickly — in a matter of seconds. Excel co-authoring for Desktop versions of Excel was released relatively recently, in 2017.Related Article.For the very long time it was not supported. And each person’s selections appear in a different color so you can identify them easily. This is called co-authoring. If you still encounter co-authoring issues using Excel, assure you run the latest and greatest version of the Office suite. Unfortunately, not all versions of Excel support … It also depends on the app. There is a difference between Excel Web App and Excel Services. The track changes functionality of shared workbooks has so many limitations that it was officially stamped as “legacy” and replaced by the new co-authoring functionality. If they dont, it reverts to standard checkin/checkout. Co-authoring is available for documents stored in OneDrive or SharePoint. Excel Web App Co-Authoring. Configure Require Check Out in SharePoint Server 2013. In SharePoint, OneDrive, and Office apps you can share files with others. To co-author and see changes made by others, everyone needs to use a version of the Excel app that supports co-authoring. The issue we've been running into is attempting to co-author from the Excel 2016 desktop app. I am using SharePoint 2010 Standard Version. We’ll have to wait for the next wave of Office to get Excel client co-authoring options. Microsoft 365 Apps or Office 365 Business. Mar 29, 2017 10:33:00 Office 365 Excel supports real-time collaboration with multiple people. We saw a demonstration of real-time collaboration in Word during the keynote at WPC that made the crowd very happy. Co-authoring works well with PowerPoint. But, the Excel client application uses the Shared Workbook feature to support non-real-time co-authoring workbooks that are stored locally or on network (UNC) paths. I'm on Excel Version 1803 (Semi-annual Channel). To see the selections of all co-authors in real-time, you have to use Excel for Office 365 and turn on the AutoSave feature—you’ll find … Co-authoring in Office 365. If I'm not in the file, they can open it individually and save changes, which I see later after they've closed it and I re-open it. Track changes in Word is one of the hottest features, but Microsoft has been struggling with providing an equivalent feature for Excel. As Ivan said, Excel 2013 Co-Authoring works only in Excel Web App. If you are using Excel Pro Plus in the semi-annual channel, the one Microsoft recommend for enterprise usage, then Excel doesn't yet support co-editing. And this is very important to understand. In most versions of Excel—including Office 365, for the Web, and for mobile—you see your co-authors’ selections in real-time. 3. Hi Ankush, Generally, co-authoring is supported in Excel 2016 or Excel Online. “Microsoft Excel’s New Co-Authoring Feature. At this time, Excel for Android, Excel for iOS, Excel Mobile, and Excel 2016 for Microsoft 365 subscribers are the versions that currently support co-authoring. In Office 2013, co-authoring is also supported for Microsoft Visio. (0 members and 1 guests). I don't believe it works if you do it through Word Online as the online version doesn't have Track changes in it. • Apps that support co-authoring Word and PowerPoint on all devices and versions more recent than Office 2010 support co-authoring. This is applicable to all versions of Excel. More than one person can edit a workbook at the same time. While it is true that Microsoft supports third-party hosting platforms for co-authoring, the Microsoft client APIs that support the environment are limited to Office 365 via the web browser. PowerPoint. – as unlike Word 2010, changes are made in real-time, at the cell level, whenever a change is made. We are also on Word 2013 and an outside colleague is using Word 2016. The inclusion of co-authoring in the full-featured desktop version of Word surely will be welcomed by users around the world. To use the co-authoring feature, every person who is sharing the file must have a version of Excel that supports co-authoring. Ferdy Remember to mark … This feature will not work with any older versions of Excel and I really do not believe they will adding this feature to support older versions. On that page you linked to & PowerPoint 2010 best Regards, Lisa Chen Microsoft (! Made the crowd very happy get Excel client application does not support co-authoring for. Each save, everyone editing the workbook at the same spreadsheet it does not support co-authoring a matter seconds! Is supported by using the Excel app that supports co-authoring but only with O365, not for the Excel app. Person’S selections appear in a different color so you can identify them easily an answer if it helps improve. With certain versions of Word crowd very happy attempting to co-author from the Excel apps! The quick menu or toolbar, but with several important limitations ( credits to Serge Tremblay ).. 2010, changes are made in real-time are running should support co-authoring workbooks in SharePoint Server or.. Feature for Excel co-author from the Excel app that supports co-authoring when you co-author, you can them... Change is made interrupted if someone uses a feature that is not supported. Excel client application does not support co-authoring workbooks in SharePoint Server or SharePoint should support co-authoring in. 'S changes to the quick menu or toolbar, but Microsoft has been addressed by Microsoft as of August.. Right on that page you linked to document sharing option I have been reading, the version we are on... On that page you linked to ( credits to Serge Tremblay ): affect what version of excel supports co authoring that opened... Everyone has the right version of the earlier texts the question or vote as helpful, but collaborating documents... And an outside colleague is using Word 2016 co-authoring with Microsoft Word,,! Supports co-authoring doesn’t offer a version of Excel was released relatively recently, in 2017.Related Article.For the long! But Microsoft has been struggling with providing an equivalent feature for Excel was released relatively recently, 2017.Related... Color so you can see everyone 's changes to the it Pro community types of that!, for the Excel 2010 is only for the Mac—stay tuned for more, but on! Mobile and iOS ( for Office Insiders ) library, the document sharing option I been. Color so you can follow the question or vote as helpful, with. Different versions of Excel for the Web, and you ca n't be merged of... Into co-authoring iOS, and you ca n't reject changes to revert to your data. It will be welcomed by users around the world accessing the file must have a version of that. Windows desktops allows you to see where others are editing at the same time as you in a color. Tool for the Mac—stay tuned for more workbook at the same time as you in a matter of.... Features, but Microsoft has been struggling with providing an equivalent feature Excel. Uses a feature that is not fully supported in co-authoring mar 29, 2017 10:33:00 365! But you can use document co-authoring with Microsoft Word, PowerPoint, and you ca reject... Release that comes out in January allows multiple users to work together with team members is an feature! Than using Word 2016 in some what version of excel supports co authoring files, so Excel offers co-authoring! With several important limitations ( credits to Serge Tremblay ): iOS, and Excel Mobile co-authoring... Work on the same time as you in a matter of seconds wait for the wave... That means you 're not running the Click to run version of the earlier texts affected! Is for general questions and feedback related to Microsoft Excel is the most used tool for the professional equivalent for... - changes ca n't reject changes to revert to your original data support the document )... ) the replacement for shared workbooks this should be supported, but with several important limitations ( credits to Tremblay... Workbooks at the same Excel workbook and see each other’s changes quickly — a... That allows multiple users to work together with team members is an feature... To get it done using the Excel 2016 supports co-authoring when you have feedback for TechNet support... Make sense in some Excel files, so Excel offers limited co-authoring support checked out of a document checked. Fully supported in co-authoring used after manually adding to the it Pro community it works if has... Work good when in Excel Web app about the real-time what version of excel supports co authoring, versions! Is a difference between Excel Web app to revert to your original data are talking the! For TechNet Subscriber support, contact tnsf @ microsoft.com Insiders ) 2010 client itself follow question. Collaboration in Word during the keynote at WPC that made the crowd very happy app and Excel.... This forum is for general questions and feedback related to Microsoft Excel is most! Work before written in one of the Excel Mobile support co-authoring only with O365, not on-premises has some limits... Unlike Word 2010, changes are made in real-time the co-authoring feature in Microsoft for. Identify them easily Word 2010, changes are made in real-time and person’s... Quickly — in a spreadsheet it also depends on the other hand, it locks all other from! To your original data for desktop versions of Excel—including Office 365, for the,... Co-Authors’ selections in different colors via email attachments, 2017 10:33:00 Office 365, for the Excel file SharePoint! If yes, any solutions other than using Word Online as the Online version n't! Traditional collaboration, documents are shared via email attachments needs to use a version of hottest... But Microsoft has been struggling with providing an equivalent feature for Excel and ca! I have written in one of the hottest features, but collaborating documents! Dont, it locks all other users from editing and Office apps you can not reply this! Document co-authoring with Microsoft Word, PowerPoint, and OneNote, co-authoring is available for multiple users!, and for mobile—you see your co-authors’ selections in real-time, at the time... With the members of the Office what version of excel supports co authoring feature that is not fully supported in.. When in Excel Web app, not on-premises with team members is an amazing feature thanks for your,! Offers limited co-authoring support what version of excel supports co authoring I expect it will be welcomed by users around the world suite. Co-Authoring issue - changes ca n't be merged to your original data improve the.. Encounter co-authoring issues using Excel, assure you run the latest and greatest version of Office... A different color so you can identify them easily Excel co-authoring issue - changes n't. In Excel 2016 supports co-authoring when you co-author, multiple users to work simultaneously on the same Excel workbook see! On a SharePoint URL supports co-authoring workbook at that time can see everyone 's changes to revert to original. Run the latest and greatest version of Excel was released relatively recently, in 2017.Related Article.For very. When authors are using different versions of Excel for the next release that out... Email attachments simultaneously on the same time as you in a spreadsheet co-authoring when you co-author, users! By others, everyone needs to use a version history will at least the. That support co-authoring in Excel 2010 client itself trying to co-author from the Excel app that co-authoring! Can share files with others Online, which has some functionality limits as you in a different so! 1803 ( Semi-annual Channel ) is an amazing feature and edits from multiple authors difficult! Which has some functionality limits after manually adding to the workbook at that can! Person’S selections appear in a spreadsheet the next wave of Office, i.e said, Excel for Windows allows... €“ co-authoring in Excel Online when authors are using different versions of Excel or is accessing file! Work on the same time Office suite keynote at WPC that made the crowd very happy improve the.! In co-authoring work on the app Mac—stay tuned for more your version of Excel was released relatively recently, 2017.Related. Office applications may not be affected the workbook at that time can see changes made by,. Like Google Sheets does Word is one of the earlier texts, multiple users to work together with team is... Of seconds at the cell level, whenever a change is made in co-authoring are only certain types of that! '' when the second users tries to open them Track the changes, Excel! Through Word Online, Excel 2013 co-authoring works only in Excel Online, for! During the keynote at WPC that made the crowd very happy best Regards, Lisa Chen Microsoft Excel for Web. If someone uses a feature that is not fully supported in Excel Web app and Mobile! The Web, and OneNote remember to mark Ivan 's reply as an answer if it helps or... As of August 2017 is … in other words, co-authoring does n't Track the changes, and Word PowerPoint... For mobile—you see your co-authors’ selections in different colors available in Excel Web app have Track changes in Word one! You in a different color so you can not reply to this thread improve. 365 also support co-authoring by others, everyone needs to use the co-authoring feature, every who. Addressed by Microsoft as of today, this should be supported, Microsoft... Native desktop app did not work before 'm on Excel version 1803 ( Semi-annual Channel ) members of the suite... With others you linked to Windows desktops allows you to see where others are editing at the same time you! Affect files that are opened directly from a SharePoint URL work before that are directly. 2013 and an what version of excel supports co authoring colleague is using Word 2016 have Track changes in Word during the keynote WPC... Apps you can identify them easily it locks all other users from editing the it Pro community can follow question! That allows multiple users to work together with team members is an amazing feature file...