• July 17, 2017
    Announcement: New site design for Microsoft Community

    In July, Microsoft will roll out the first of ongoing site improvements aimed to modernize Microsoft Community and help customers get the most out of their community experience.

    • During the roll out period, you may see the old or new site design depending on your location

    • We expect the roll out to finish by 31 July

    Note: Past private message conversations will not move to the new site design. Please save any private messages you would like to keep.

     Learn more about the upcoming site improvements in this thread.

    Thank you for being part of Microsoft Community!

 
Discussion
  • Important thread
8575 views

Co-authoring comes to Excel for Windows desktop - Insider Slow

MC_FAD started on

Update: Co-authoring has been released to Insider Slow in Version 1707 (Build 8326.2033)

Hello Insiders –

Today, we’re enabling co-authoring in Excel on Windows desktops, for Office 365 subscribers in the Slow level of the Office Insider program. This means you can work at the same time with others in any shared cloud document without missing a beat. No more locks on Excel files!

Starting with Excel Version 1707 (Build 8326.2033) for Excel on Windows desktop, you can co-author with others and no longer worry about getting locked out of a shared file that’s stored in SharePoint Online, OneDrive or OneDrive for Business. With Excel co-authoring you’ll find it’s easy to know who else is working with you in a spreadsheet, and you view their changes automatically in seconds. Co-authoring is already available in Excel Online, Excel on Android (7830.1012 or later), Windows Mobile (7830.1013 or later) and iOS (for Office Insiders) and we’re working on co-authoring in Excel on the Mac —stay tuned for more!

We’re also bringing AutoSave to Word, Excel and PowerPoint on Windows desktops, for files stored in SharePoint Online, OneDrive or OneDrive for Business. With AutoSave, you can stop worrying about hitting the save button, whether you’re working alone or together with others. So, you can rest assured that your changes are saved automatically.

Availability

To use co-authoring in Excel on Windows desktops, you must:

  1. Be an Office 365 subscriber and opted into the Slow level of the Office Insider program
  2. Have Version 8326.2033 or later installed
  3. Save your file to SharePoint Online, OneDrive or OneDrive for Business.
  4. Work with another user who is on a co-auth enabled platform
  5. Share your file with others in the Insiders program

Note - You can co-author with others not in the Insiders program however they will not be able to take advantage of co-authoring on Excel on Windows desktop and must use another supported version (Excel Online, Excel on Android or Windows Mobile)

Open the file and work in it together at the same time

To use AutoSave in Excel, you must:

  1. Be an Office 365 subscriber and opted into the Slow level of the Office Insider program
  2. Have Version 8326.2033 or later installed
  3. Use .xlsx, .xlsm, or .xlsb files. If your file isn’t in this format, open the file and then click File > Save As > Browse > Save as type. Change the format to .xlsx, .xlsm, or .xlsb.
  4. Save your file to a shared location

Getting Started with co-authoring

Start by uploading a workbook to a supported, shared cloud location such as SharePoint Online, OneDrive or OneDrive for Business.

Share your workbook with others- If you clicked the Share button, people will receive an email message inviting them to open the file. They can click the link to open the workbook, a web browser will open, and the workbook will open in Excel Online. To use co-authoring in Excel on Windows desktop, click Edit Workbook > Edit in Excel. However, these users will need a version of Excel that supports co-authoring.

Co-authoring is currently supported for all customers in Excel Online, Excel on Android and Excel Mobile on Windows. Co-authoring is currently available in Excel on Windows desktops for Office 365 subscribers in the Fast level of the Office Insider program. Co-authoring is currently available in Excel on iOS for Office Insiders. If the people you are collaborating with you do not have a supported version of one of these apps, they can co-author using Excel Online by clicking Edit Workbook > Edit in Browser.

Now you’re ready to start co-authoring. Once you’ve shared your workbook with others as described above, you can begin to edit in the workbook at the same time, and when you’re co-authoring using Excel on Windows desktop, you’ll know you're co-authoring if you see pictures of people in the ribbon.

When you are co-authoring, you can see each other's changes in a matter of seconds and when co-authoring in Excel on Windows desktop or Excel Online you'll see other people's selections in a colored box around the cell they’re working in, represented with different colors. This allows you to quickly determine where others are working to avoid working in the same cell at the same time.

Co-authoring tips: When using Excel on Windows desktop, if you want to jump to where someone is working, click their picture or initials, and then click the Go to option. You might see other people's selections in different colors. This happens when you are both using either Excel on Windows desktops or Excel Online. If they're using another version you won't see their selections, but their changes will appear as they are working. If you see other people's selections in different colors, they'll show up as blue, purple and so on. However, your selection will always be green. And on other people’s screens, their own selections will be green as well. If you lose track of who’s who, rest your cursor over the selection, and the person’s name will be revealed.

Learn more about co-authoring in Excel.

Excel AutoSave

In Excel on Windows desktops, Office 365 subscribers might notice an AutoSave option in the upper-left corner. AutoSave is enabled when a file is stored on the cloud. When we say “cloud,” we mean SharePoint Online, OneDrive or OneDrive for Business. AutoSave automatically saves your changes to the cloud as you are working. And, if other people are working on the same file, AutoSave lets them see your changes almost instantly. When co-authoring with other people, AutoSave will save every few seconds. Although the time can vary depending on what you are working on.

Learn more about AutoSave in Excel.

Try the following scenarios:

Open the same Excel file for editing using Excel on two different Windows desktops at the same time.

Co-authoring is now available in Excel on Windows desktops for Office 365 subscribers in the Fast level of the Office Insider program. Previously, you would get locked out of an Excel file and would not be able to edit it if you left the file open on another machine, or if another user had it open at the same time. We have now given you the ability to always access your file for editing whether you left it open on another machine or other colleagues have it open at the same time. No more lockouts on Excel files!   

  1. On a Windows PC, use Excel to open an existing file stored on SharePoint Online, OneDrive or OneDrive for Business.
  2. On another machine, open the same file from the Recent list in the File > Open tab. You will be able to successfully open the same file on both machines, without seeing a “File in Use” dialog that blocked you from accessing the file on the second machine.
  3. In addition to not being locked-out when you make changes in either file and you should see them quickly appear in your second file.

Co-author in an Excel file with others while simultaneously using Excel on Windows desktops.

* For this scenario, you’ll need to work with other Office Insiders. We recommend contacting others through personal message. 

  1. On a Windows PC, use Excel to open an existing file stored on SharePoint Online, OneDrive or OneDrive for Business.
  2. Share the file with others (must be others in the Insiders program to take advantage of Excel on Windows desktop) using the Share option in the top right and select the default “Edit” permissions. Alternatively, you can use a file on a shared file location such as a SharePoint Online document library (team site) which is already shared with your team if others on your team are also in the Insiders program.
  3. *Team up with one or more other Insiders and edit the file simultaneously with them.
  4. When others join the file, you should be notified with an in-app notification and when you are using Excel on a Windows desktop, you will be able to see where they are working within the workbook.

Co-author in an Excel file with others simultaneously using Excel Online, Excel on Android and Excel Mobile on Windows.

  1. On a Windows PC, use Excel to open an existing file stored on SharePoint Online, OneDrive or OneDrive for Business.
  2. Share the file with others who are using a version of Excel that supports co-authoring and using the Share option in the top right and select the default “Edit” permissions. Alternatively, you can use a file on a shared file location such as a SharePoint Online document library (team site) which is already shared with your team if others on your team are also in the Insiders program.
  3. Team up with one or more others and edit the file simultaneously with them.4.     When others join the file, you should be notified with an in-app notification. If you are using Excel on a Windows desktop, you will be able to see where they are working within the workbook.

Learn how to get Office Insider Fast builds of Office for Windows desktops.

Go ahead and try it and please share your feedback. We want to hear from you.

  • Supply feedback directly from within the app. Go to File > Feedback
  • Take the in-app Survey

Thanks!

Scott and the Excel Team

Resources

How Office 365 commercial customers can get early access to new Office 2016 features

What's new in Excel 2016 for Windows for Office Insiders

30 people have recommended this discussion

Abuse history


progress