The new Threaded Comments that appeared in Build 1809 are awesome for 99% of the people. But for the Commenting Gurus - anyone who has ever taken the time to build help systems by resizing, re-coloring, re-shaping and using Show All Comments, we are going to see our comments get destroyed by well-meaning co-workers.

Yes, all of the legacy icons are available for adding back to the Ribbon, but we the comment gurus can not trust our co-workers and managers to take the time to add these.

My request: If Excel detects any comment in the workbook that is a different color, a different size, a different shape, holds a photo, or if Show Comment is turned on, then *do not offer* our co-workers the option to "Reply to Comment" and then default to "Convert Comments". That "Convert Comments" button is global and permanent and might as well say "Undo all the work that our genius co-worker did in building this help system."

At the very least, add "Edit Comment (Legacy)" to the right-click menu, just above "Reply to Comment" so we have a 50/50 shot that our comments will not be destroyed by our manager. Please.

Every time (many days a year) I train people in Excel, someone ask why there is no button or shortcut to obtain a number format with "thousand separator and no decimals". At least - in northern Europe - this is the most common used number format. If "button-solution" not possible for Microsoft in order to have common buttons world-wide, at least a shortcut for this has been much appreciated. (Note that the current button for thousand separator and two decimals could not be used, though the alignment in that format are not disired/good and two decimals used).
Today I teach student to:
1) be quick to hit Ctrl+1 -- Tab - down arrow -- Tab -- downarrow -- Tab -- space -- Enter
2) Use my macro button - but hornestly, I hate to have macro for something common and simple due to lack of "undo".
3) Maybe some day (and I said that for 10 years now) Microsoft will do it :-)

This has been a bug (in my mind) forever. For some reason, if you have an Excel shape nicely formatted and you go to link it to a cell to make the text dynamic, all the text formatting gets reset. This is really extremely annoying if you are creating a visually stimulating dashboard and want to duplicate a bunch of perfectly formatted shapes. Proceeding to link the shapes to various cells so that they display your data completely resets the formatting.

I created a VBA workaround to make it seem like the text format is retained, but this functionality should really be integrated into Excel itself.

Link to VBA workaround: https://www.thespreadsheetguru.com/blog/retain-font-formats-after-changing-excel-shapes-formula-link

Incorrect values of dimension in pivot table sourced on OLAP cube (Microsoft SSAS 11.0.5569.0). The latest version without that bug is 16.0.6001.1068. Obviously we don’t know exact source of this bug, but most of the issues we discovered were on complex pivot tables with many attributes, partially displayed dimension’s hierarchy and without subtotals. Example of this bug occurring is in attached file ExcelBug. There are 2 exactly the same pivot tables (the table on the right hand side is basically copy of the table on the left hand side). After removing “Grand Total” on the table on the right hand side some fields have incorrect data displayed.
In this example field B4 contains correct value: „5 Name” (coloured green), field G4 (after removing grand total) contains wrong value: „6 Name” (coloured red).
Video https://youtu.be/RRwfAQVGBfc shows steps to change data source of pivot table and the bug itself. Files ExcelBugSSAS.abf and ExcelBugDBMSSQL.bak are backups of SSAS cube and database with all metadata and data to recreate this scenario in any environment (with SQL Server 2012).

Do you hate Merged Cells? Do you believe Merged Cells are evil? Do you curse every time your selection rectangle goes from one column to five columns just because you touched a merged cell? Do you constantly get workbooks from co-workers who continue to merge cells? Tired of not being able to Sort or Paste because someone merged a cell?

Excel encourages people to use Merge & Center by offering it front-and-center on the Home tab. Thus, few people discover the (superior) Center Across Selection option on the Alignment tab of the Format Cells dialog.

Currently, the Merge & Center drop-down offers: Merge & Center, Merge Across, Merge Cells, UnMerge.

My request: Adding a fifth item of "Center Across Selection" to the drop-down.

As a bonus, add a tool tip explaining the perils of merged cells and how Center Across Selection is superior in nearly every way.

Thanks for voting!