Windows 10: Co-authoring comes to Excel on Windows desktops

Brink · Mar 27, 2017

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:

Be an Office 365 subscriber and opted into the Fast level of the Office Insider program

Have Version 8017.1000or later installed

Save your file to SharePoint Online, OneDrive or OneDrive for Business.

Work with another user who is on a co-auth enabled platform

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:

Be an Office 365 subscriber and opted into the Fast level of the Office Insider program

Have Version 8017.1000 or later installed

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.

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!

On a Windows PC, use Excel to open an existing file stored on SharePoint Online, OneDrive or OneDrive for Business.

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.

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.

On a Windows PC, use Excel to open an existing file stored on SharePoint Online, OneDrive or OneDrive for Business.

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.

*Team up with one or more other Insiders and edit the file simultaneously with them.

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.

On a Windows PC, use Excel to open an existing file stored on SharePoint Online, OneDrive or OneDrive for Business.

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.

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
Click to expand...

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

:)

LizMummy · Mar 27, 2017

Windows 10. I can't save an excel sheet

So I've created a small, very simple excel spreadsheet. Click Save As. It produces a list of destinations including Documents, Desktop etc. I click on documents and get precisely nothing. No error message. No co-operation. Any suggestions?

Beedle · Mar 27, 2017

Issue with xlt files after upgrade to Windows 10

We have a custom reporting engine built that uses Excel templates (.xlt) populated with data from SQL and formatted using various .NET formatting engines we built. Once I upgraded to Windows 10, any template I attempt to create/update comes back from
our report engine in protected view (says there's a problem with the file, but doesn't have any specifics). I confirmed it was most likely due to the upgrade once one of my co-workers also upgraded and experienced the same thing (we're the only 2 on Windows
10 here). I am currently having another co-worker on Windows 8 or below open the template and re-save in order to correct for this. I've tried both Excel 2010 and 2013 installs from our Office 365 subscription with the same results. Any idea's?

Windows 10: Co-authoring comes to Excel on Windows desktops

Co-authoring comes to Excel on Windows desktops

Co-authoring comes to Excel on Windows desktops

Co-authoring comes to Excel on Windows desktops - Similar Threads - authoring comes Excel

Sharepoint co-authoring works

Sharepoint co-authoring works

Co-Pilot Desktop and Co-Pilot in Edge no Longer working.

Co-Pilot Desktop and Co-Pilot in Edge no Longer working.

Co pilot replaces show desktop

Live editing co-authors limit

Live editing co-authors limit

OneDrive Co-Authoring Executable constantly using 25% CPU

Windows Defender Firewall blocked Microsoft OneDriveFile Co-Authoring Executable