You can earn a commission for sales leads that you send to us by joining our Any affiliate commissions that weĮarn when you click a link to Amazon or other sites is reinvested in keeping Web site are provided "as is" and we do not guarantee that they can be used in all
The Formulas, Functions and Visual Basic procedures on this provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly. There are good things and bad things that you need to get used to when you are co-authoring. Rather than dealing with these rules, be happy that co-authoring mostly works and have everyone agree not to edit the same cell at the same time.Ĭo-authoring is a whole new experience. When someone (probably your manager), dives in to edit a cell that you are already editing, then a confusing set of rules decides who's edit wins. If you want to know who is editing a cell, hover over that cell.Ĭo-authoring will work fine provided everyone avoids editing the same cell at the same time. The active cells for others will be other colors.
While you and others are working in a document, your active cell will be outlined in green. This is the only way to have everyone co-author and use the real desktop Excel instead of Excel Online. Once they have signed in, then the Edit Workbook drop-down menu appears. Use the credentials that are shown in Excel under File, Account. Not so obvious in the top right corner is the Sign In button.įor the other co-authors to use the workbook in the real version of Excel running on a PC, they have to first Sign In to Excel online. In desperation, you might try clicking Download, but this removes the ability to co-author. One person (the workbook owner) would edit in Excel and everyone else was stuck in Excel Online.Īs shown below, the "Edit in Browser" button is very prominent and it is what you are likely to click. I talked to people from one company who stopped at this point. The spreadsheet will appear and they can edit in Excel Online. When they follow the link, they will be taken as a guest to Excel Online. Generate a sharing link where anyone with the link can edit the workbook.Ĭopy the link and send it to others on your team. The Share panel asks you to invite people by e-mail address.īut if you look at the bottom of the panel, you can generate a sharing link. The owner of the workbook clicks the Share icon in the top right corner of Excel. The owner of the document should use File, Save As and choose to save the document in either OneDrive or SharePoint Online. This person should already have a One Drive For Business or SharePoint Online folder set up. To start, choose one person to be the owner of the workbook. But it is difficult to figure out all of the steps to allow multiple people to use Excel on their computers instead of having some people stuck using Excel online. The feature works well once you get it set up. The feature was released to Office 365 customers in the summer of 2017. People resorted to only one person having write access at a time", which led to someone opening the file and then forgetting to close it before going for a two-hour lunch and tying up the file that whole time.Īfter Google's spreadsheet product began offering the ability for multiple people to edit the same worksheet, the Excel team spent over two years developing a feature that they call co-authoring. The old Shared Workbook functionality was awkward. For decades, some people have been wanting a better way to have multiple people in the same workbook at the same time.
0 kommentar(er)
