In a shared document, other team members may be waiting for me to make some changes or I may have a question about something in the doc. There should be a way to click on the share button and then send an email notification to those shared on the workbook: "Hey folks, I just got such and such done, so now you can do x, y, or z" or "Can someone explain why ...."

We have strict date format rules for documenting R&D work. It would be nice to set that to default date format no matter who opens the file (internal, external, US, UK, etc.). Currently, the only open is to change each date using Custom Date format and copying and pasting the format, which is tedious. I'm not sure if enabling in the Options would be the solution.

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

Simple option analogues to "find and replace" can be added.
Step 1- Select the cells you want to apply currency conversion
Step 2- Either excel automatically detects what currency it is or you can select what currency it is on the cell
Step 3- select the currency you want to convert to? select the exchange rate(users should have options to use real time rated or predefined at that moment)
Step 4- Your cell have been converted to desired currency.

As owner of a workbook I don't want other users to amend formulas. I do however reserve the right to amend them myself. This functionality would allow me to make edits remotely without losing my control over the integrity of the calculations in the workbook.

Hi there, the new auto save function causing more problems than it is resolving because it is on by default regardless of the nature of the workbooks. I recommend that the user is rather prompted to enable autosave on workbooks with macros or with file sizes > 1Mb instead of enabling it by default.

have it so i can click a gmail logo and it will send me to my gmail account with the attached form in the new email......

or have it like google docs i can see other people edit it at the same time as me

Add Comment Pane similar to MS Word in Excel. It's exceptional hard to see comments in Excel this would really help.

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.

When you are editing a file on a shared drive, you should allow the user to "attach" a UNC link to the file in the same way you provide Sharepoint/OneDrive links.

As extra credit, you should check to make sure that the recipients have access to the file (at the very least, you should warn if sending to external email addresses).

WHEN YOU OPEN AN EXCEL FILE AND SOMEONE ELSE ALREADY HAS IT OPEN, THEN A BOX SHOULD POP UP TELLING THE USER THAT IT IS READ ONLY.

When I an in excel and go file, share, email as a pdf I only want to share the current tab not the whole spreadsheet. The print dialog box should come up so I can choose what I want to share.

To be able to add comments to a specific data labels in a chart (can be bar chart, line chart)

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

Excel 2016 workbooks open in read only mode from SharePoint and Edit needs to be enabled everytime.

I open and edit the same workbook 100 times every day. I wish that I could open the Excel without clicking the Edit button every single time.

On the File > Export screen, a single button to "Export all sheets as CSV files" would be awesome. It can use the sheet name to name the files.