Users should be able to Right-Click on a column in the Power Query editor and have the option to hide the column from view when it is loaded. Currently the only option is to completely remove the column altogether....

Range.Text should be able to return an array of results instead of only being able to return the text for a single cell. Its behavior should be consistent with Range.Value and Range.Value2.

Additionally, Range.Text should never return a result like '#####' when the column width of the cell is too small. It should always return the text that would be visible if the column was wide enough (and calling Range.Columns.AutoFit before calling Range.Text should not be necessary).

the Range.NoProofing property would let you mark ranges, cells, table rows or columns as exempt from Spell checking.

Outlook and word have this property and it helps prevent pollution of the custom dictionaries.

Microsoft recently acquired Revolution Analytics:

http://revolutionanalytics.com/

Revolution R Open with MKL is an open source derivative of R (RRO + MKL). Adding-in RRO to Excel is a natural fit and will extend the scripting utility of .xlsx in Enterprise environment. The package developments alone are worth considering this integration.

When programming the ribbon in VBA, if the code is ended, the ribbon pointer is lost and there is no means of recovering it without reopening the workbook. It should be possible to recover the ribbon object. (There is an unofficial workround involving copying memory, but this is hardly desirable).

Power Query Self Appending Query

I've built a few self appending Power Queries by modifying the M in advanced editor - It would be nice to have the functionality built into the GUI.

The Query would read the loaded query data from the related ListObject (or data model) into memory while asynchronously querying another data source. The data from the other data source would be append to the previously loaded data set then either load the table or load back to the data model after removing duplicates(optional).

there is a WorkbookBeforeClose event but there is no corresponding WorkbookAfterClose event.

Note that the WorkbookBeforeClose is cancelable so there is no guarantee that the workbook will actually be closed after that event is triggered.

Currently in order to get the WorkbookAfterClose event, a workaround needs to be implemented: https://exceptionalcode.wordpress.com/2010/02/11/how-to-get-an-excel-vsto-workbook-closed-event/

There are functions to get the intersect or union of two ranges, but there exists no built in function to get the difference between two ranges.

When I say difference, I mean A - B = A ∩ B' where B' is the complement of B

Add a barcode insert for Excel. Rather than relying on 3rd party applications.

Worksheet Object does not fire a Worksheet.BeforeChange or Worksheet.Changing event. For our use case, which is for auditing and potentially preventing changes done to Excel Sheets by specific users, we get the event after things have changed.

We have a specific set of cells that should changeable by only a few users so we use .net interop to get user credentials from Active Directory.

Let us code macros directly in C#!

In previous versions of Excel you could create a Book.xlt and make that the default template for new workbooks by saving it in the XLSTART folder. That does not work with the Start Screen/Back Stage in Excel 2013 and 2016 which makes it imposibole to provide customers with a custom template for new workbooks with customized colors, fonts etc. Please make it posible to attach the Empty Workbook option to a customized template. (It still works in Word 2013)

Certain types of macros could be guaranteed to be safe to the user of a workbook. Such an example would be a UDF that does pure numerical manipulation.
I propose that there is some mechanism to detect whether VBA could have unwanted side effects and block those, but workbooks containing only VBA that does pure numerical manipulations or makes use of only other worksheet functions should be enabled by default.

The parameters of some VBA functions have a 255 character limit which makes some functionality impossible.

Examples:
* Worksheet.Evaluate()
* Application.ConvertFormula()

Please can we have the OnKeyPress, OnKeyUp and OnKeyDown events exposed in Excel please?

It is a real and unnecessary pain to have to use the API to do this simple thing.