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

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 and Excel on the Mac (16.9.18011602 or later). Coauthoring is not yet available for customers in the Semi-annual channel. 

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.

For more information and the latest details on coauthoring availability please refer to the "what you need to co-author" section of the co-author support article, Collaborate on Excel workbooks at the same time with co-authoring

Availability

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

  1. Be an Office 365 subscriber in the current channel release (coauth is not yet available for SA customers) 
  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, iOS, Mac 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, iOS and Mac and Excel Mobile on Windows. Co-authoring is currently available in Excel on Windows desktops for Office 365 subscribers on a current channel release. 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

Was this discussion helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this discussion?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this discussion?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

Its about d@mn time.

9 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Will this work with excel documents that have macros within the document?

104 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Will this work with excel documents that have macros within the document?
XLSM files are supported.

19 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I think the "AutoSave" feature is too aggressive. If I open a file and just navigate, it is autosaved, thus updating the modified date. Also increases substantially the number of versions saved in history.

Also increases the risk of saving bad data for those of us used to opening Excel files and messing around with them and then closing them without saving.

I'd almost want AutoSave to be an option at time of open (like "EDIT" in the yellow bar) unless AutoSave was required if the file was being co-authored at the time of open.


17 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

In Excel in build 16.0.8017.1000 Power Pivot does not work
I have OfficeProPlus 365 x 64 bit
Is this my problem or a bug in the build?
OfficeProPlus 365 x 64
Win10 x 64
HP EliteBook8570w, i7, 24GB Ram

5 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 Is Auto-Save turned on for all documents saved to OneDrive/Sharepoint and opened in Excel Desktop or only when that document is being viewed or worked on by others?  I also agree that Auto-Save should be a optional and turned off by default.  That said, I'm not sure how you would collaborate with someone else if it was turned off. 

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

PowerPivot works for me - just used it. Maybe try unchecking the Addin in Excel's Addin settings, quitting Excel, restarting it, then reading it?

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Autosave is turned on for all workbooks opened in Excel on desktop by default, even if the workbook is not being edited by another user. If you don’t want to show your changes right away, you can turn AutoSave off. Then, when you’re ready, click Save to show your changes to the other people working on the file. (Or, you can also turn the AutoSave switch back on to save and share your changes.)

The default for AutoSave is to always be On for files that are on the cloud. However, if you turn AutoSave Off for a file, the program will remember and will keep it off every time you reopen that file. If you switch it back On for a file, it will remember to keep in on for that file.

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Does not work. On two laptops in the build 16.0.8017.1000 Power Pivot does not work.
Installed the build 16.0.7967.2030 and all Ok.

OfficeProPlus 365 x 64 bit

OfficeProPlus 365 x 64
Win10 x 64
HP EliteBook8570w, i7, 24GB Ram

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I always though this was a feature introduced 1.5 years ago with the release of Office 2016. Why is co-authoring suddenly new again in 2017? Where is the difference?

6 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

* Please try a lower page number.

* Please enter only numbers.

* Please try a lower page number.

* Please enter only numbers.

 
 

Discussion Info


Last updated July 7, 2023 Views 37,573 Applies to: