These are currently two separate export options, email vs export to pdf.
So emailing a worksheet as pdf turns into a six steps process: 1) export to pdf; 2) choose folder and save; 3) switch to outlook; 4) create email; 5) add attachment; 6) choose folder then pdf file. If lucky, it can go a couple steps down when outlooks prelists recent pdf created as attachment candidates.
The current option available in excel "Email as PDF attachment" converts whole workbook as PDF for Mail attachment.

Can we improve on this and add a pop option similar to the option we get for "send to mail recipient " giving the option to select current worksheet or whole workbook as attachment.

I have on 1 workbook anywhere from 5 to 50 individual sheets tabs open for my events. When i try to email an individual event to a specific client it only allows me to email the entire work book with all other events on it. Then it prompts me to save a copy of one individual sheet tab as its own work book and email it out that way. that means that i would have to save a copy and email out each individual sheet tab. Counter productive and takes too long. Can it be fixed to where you can just right click a sheet tab and the option to email that individual one out will be on there. This will help many employers who have multiple works on 1 excel workbook. Thank you.

Co-authoring with SharePoint Online and Excel desktop applications is a plague for years. This has to be the most common problem that keeps coming back up over and over. For whatever reason Excel files become read-only locked for all users accept for the last person that made an edit with the desktop application. All other users are prompted to save a copy of the file.

Microsoft you need to figure this issue out. Devise a way for the local office cache to resolve itself, or fix autosave, or the other myriad of options which is causing this ongoing conflict to keep happening.

We have a work file in which 30 people are actively contributing.

A substantial portion of the users are "data capturers" and have permissions to capture data into certain columns, say columns 1 to 15.

Then we have reviewers, who need to complete 5 columns for each row of captured data. There should be a feature, in Excel online, which allows for my 5 reviewers, and the 5 reviewers only, to be able to edit say columns 16 to 20.

I don't want the data capturers to be able to edit columns 16 to 20, at all.

Based on the fact that the file is shared using the Share With Specific Users feature, I don't see why it should be difficult to incorporate such permissions to specific defined ranges.

I know of so many companies who want this feature with allowable edit ranges by online user. And no, these will not be users on a local server domain. These users are all 365 users.

This applies to scenarios where making a workbook a shared file so everyone can edit at the same time isn't feasible

Sometimes when multiple people are trying to work within the same workbook, the person who is currently working in the spreadsheet will forget about it if multi-tasking and doing other things. The other people waiting have no idea if the other person is actually still working in the workbook or forgot about it or worse, is away from their desk. A solution to this would be to create a reminder that pops-up in the workbook with two buttons after 5 or 10 minutes of no activity in the workbook. The pop-up would ask if the user is still working in the workbook (response button 1 could say, "Yes, I need more time" or if they're done, give them the option to save and close out (button 2 could say "No, I'm finished.") Incorporating this into Excel and even other Microsoft Applications (word, PowerPoint, etc.) would be more efficient and encourage people in the workbook to be productive and not delay making their changes/updates.

Assume an excel file which requires feedback from many people. The file contains many lines and each line is assigned to specific person = requires feedback only from this specific person and no one else should be allowed to edit this line.
Allow Edit Ranges function should facilitate collaboration on this file, except that the lines assigned per person are frequently changing, leading the administrator of the file to manually adjust the allowed ranges assigned per person, in the Allow Edit Ranges menu.

There should be the possibility to automatically adjust the allowed ranges assigned per person in the Allow Edit Ranges, based on some formula or dynamic named range.
I tried to dynamically set names through the name manager, but it was not possible.