In Word and PowerPoint you can collaborate from the desktop as well as online. In excel, whenever anyone opens the document on desktop others get locked out of editing and can only view. This is a problem for our organisation since occasionally remote team members need to edit the file on desktop but failure to close down the document properly (either accidentally or because the OS somehow did not release the file lock which has happened on Mac's) means the entire team is suddenly unable to work for extended periods until we track down the culprit.

Excel 2016 has recently removed the share workbook functionality and hidden the icon for easily sharing workbooks. It appears that this has not taken into account spreadsheets that are saved on file servers, and aren't uploaded into the cloud (ie the co-authoring functionality). Please return the functionality so that workbooks can be easily shared.

When using co-authoring with Autosave in latest Excel desktop client, it fails if the workbook is password protected. Allow multiple users to edit a password protected workbook.

Some users use Excel for tracking of various tasks or operational reviews. At the end, follow-up minutes and tasks will have to be created. It would be great to have a function like in OneNote to create a Task in Outlook. Information about Due Date and Assignee should be embeddable into the cell with a little popup window.
When in Outlook, you should be able to click the task and go back to the Excel document (and specific cell) stored on the SharePoint.

It would be greater if I MS Office add Google Drive for user to open documents form that service as well.

allow users of shared worksheets to filter their view of the data without affecting the view of others who are also using the same spreadsheet even when saving the document.

I want to protect the queries from being changed but want users to have the capability to refresh the data model (that uses PowerPivot).

Bring back the SharePoint List sync feature enabling 2-way synchronization between an Excel table and a SharePoint Online List.

Have the ability to add Check Boxes like in OneNote - be able to simply add a check box into a cell and be able to check it off

I work on excel file with multiple sheets whenever i want to send my working i need to copy it to new excel and send it. Can we have option of sending the selected worksheet over an email as new excel file with the name as your worksheet.

This will reduce lot of time and data for not saving in multiple files. Helps user to check in single file.

With the shared worked book i would like to see if i can now merged and actually change things besides just adding rows and columns. i would like to merge,and cells and etc while also tracking what someone else is doing in the same workbook. Same goes for excel online, i like to track what the other person on the workbook is doing.

Excel may be powerful, but its security is WEAK and can be HACKED easily. There are an increasing number of competitors who offer the ability to "compile" Excel files into a .exe file. It would be better if Microsoft offered this ability themselves.

It is common to have multiple tabs in your spreadsheet and only want people you collaborate with to work on a specific tab, or at least focus on one.
I would like to be able to share a link to an Excel spreadsheet that opens the document on a specific tab.
I envision the feature to be exposed via a right click on the tab and as an additional option in the Share box which would default to the currently opened tab.

It would be useful if it was possible to share individual worksheets in an Excel workbook. I would like to be able to create a workbook with multiple sheets and share just one of those sheets with others Office 365 users.

Co-authoring works well on Excel desktop in conjunction with OneDrive based files. There is however currently no solution for businesses using Dropbox or other cloud providers.

Can we enable co-authoring with these too? Particularly Dropbox.