1.    28 Mar 2017 #1
    Join Date : Oct 2013
    Posts : 25,216
    64-bit Windows 10 Pro build 17040

    Co-authoring comes to Excel on Windows desktops


    Hello Insiders –

    Today, we’re enabling co-authoring in Excel on Windows desktops, for Office 365 subscribers in the Fast 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 Build 8017.1000 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 Fast level of the Office Insider program
    2. Have Version 8017.1000or 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 Fast level of the Office Insider program
    2. Have Version 8017.1000 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 theShare 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, clickEdit 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 AutoSaveoption in the upper-left corner. AutoSave is enabled when a file is stored on the cloud. When we say “cloud,” we meanSharePoint 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

    Source: Co-authoring comes to Excel on Windows desktops - Microsoft Community

    See also: New to Office 365 in March - co-authoring in Excel and more - Office Blogs
    Last edited by Brink; 28 Mar 2017 at 15:26.
      My ComputersSystem Spec

 


Similar Threads
Thread Forum
Multiple Desktops - Applications keep jumping between desktops on wake
I keep 2 virtual desktops, one for my personal applications and the other for official work. I have multiple windows of Google Chrome on both the desktops, some excel windows, PDF files etc. Whenever my computer wakes from sleep, the entire...
General Support
Windows 10 desktops questions
Hello guys, I have question about using multiple desktops in Win10 on my laptop. I'm using about 10 desktops for diferent purposes, and lately I've been having some problems with them. After I put laptop to sleep and wake it up again my desktops...
General Support
Multiple Desktops vs Virtual Desktops
Which would be the preferred option - W10 Multiple Desktops or a 3rd-party utility such as Dexpot...? T.
General Support
What do you guys think of installable desktops for windows 10?
What do you guys think of installable desktops for windows 10? Do you think Microsoft would ever do that?
General Support
Office Office Mix: First time authoring & publishing enhancements
Source: First time authoring and publishing enhancements - Office Blogs
Windows 10 News
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 20:03.
Find Us
Twitter Facebook Google+ Ten Forums iOS App Ten Forums Android App



Windows 10 Forums