If two people try to edit the same cell at the same time, the last one to press Enter will win. Hover over any of the boxes to see the full name of the person editing that cell.Įverything will work fine if you stay away from editing the cell that another person is currently editing. ZJ has C6 as his active cell but isn’t editing the cell. The color of the boxes corresponds to the initials shown in Figure 1. You can see the green box around cell C2. In the figure below, the Name Box indicates that you have cell C2 as your active cell. The cell pointer in Excel is the green box that surrounds whichever cell is currently active. For a longer list of shared workbooks, Microsoft has added a Shared with Me tab next to Recent and Pinned. If you select File, Home, the Recommended section of the screen will show any shared workbooks in which you were recently mentioned in a comment or that were recently shared with you. Though you share the link via email, you or your coworkers don’t need to have email open to know that someone shared a workbook, thanks to the new Home screen in Excel. You can click on any initials to see which cell that person is currently editing. The initials in the next line belong to your coworkers who are currently editing the document (#3). The name in the title bar of Excel tells you that you are currently signed in (#2). The Share icon is in the top-right corner of Excel (#1). Invite others by name or email address and send the link. You can choose to share the link with people in your organization or with anyone-though, as I said, it works best when sharing within your organization. With your workbook saved and AutoSave turned on, use the Share icon found in the top right of the Excel window. If you continue to make changes past this point, your coworkers won’t see the changes until Excel reestablishes the connection. If you lose your internet connection while working in the file, you might see a Refresh Recommended or Upload Failed message. Some features look slightly different on different platforms.Įveryone editing the workbook needs to have an active internet connection. People can edit the same workbook at the same time while using Windows, Mac, Excel on the iPhone or Android, or even Excel online. Sharing and collaboration work across multiple platforms. There should be an AutoSave switch visible, and that switch should be enabled. To make sure you have the correct version, look in the top-left corner of your Excel window. I often meet people who work at a company that subscribes to Office 365, but they’ve never taken the time to let IT upgrade their Excel 2013 or Excel 2016 to the Office 365 version of Excel. ODS formats.Įveryone who will be sharing the workbook needs to have an Office 365 subscription and the latest Office 365 version installed. But saving to an on-premise SharePoint site isn’t enough-your IT department needs to set up a SharePoint Online service. To share a workbook, you need to either save it to your OneDrive for Business folder or to a SharePoint Online folder. (If you have to share across organizations, read bit.ly/2MyKGc2 to learn about external sharing). Shared workbooks work the best when everyone is using Office 365 within the same organization, known as a “tenant” to those who maintain the Office 365 environment. While there might have been simple workbooks that could live within these limitations, the functionality was very limiting. You had to agree to avoid a long list of features that weren’t compatible with shared workbooks. It was clear that the old limitations of the legacy Shared Workbook experience weren’t practical in real life. The Excel team describes the new coauthoring experience as “Excel’s moon shot.” The team spent more than three years on the feature.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |