Excel for Windows (Desktop Application)
Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.
To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
Inquire Add-In that will work with Excel 2016 Professional, not only Pro Plus.
Provide a download for the Inquire Add-In that will work with Excel 2016 Professional, not Pro Plus.
4 votes -
Add ProgressBar control in VBA forms for Office 2016 64-bit
Is it possible to have a workbook that uses the ProgressBar control
from mscomctl in 32-bit Excel, but does not use it (and does not give
the user an error) in 64-bit Excel? Currently when I open the workbook in 64-bit Excel, I get an error that it can't find the library.3 votes -
vba code navigation
Please add 'cross references' in the code for navigation. e.g. where a function/sub is called, if the user doubleclicks or crtl+clicks on the function/sub then they get taken to it
5 votes -
Unique instances of excel please....
...without having to do this...press Windows+R (Run), then type “Excel /x” without quotes. This is not efficient
4 votes -
5 votes
-
Bring back calendar control as a vba reference
Excel 2007 supported a calendar control reference that allowed the programming of a pop-up calendar for date pick on worksheet_change. This function has been stripped from newer version of excel. The convenience of this reference can't be overstated, and ensures correct date format.
8 votes -
Fix Application.WorksheetFunction.Match
For decades Excel's Application.WorksheetFunction.Match has had return type Double, as shown in the VBA object browser. This means it throws runtime errors when there's no match for its 1st argument in its 2nd argument rather than returning an error value (#N/A).
Since Application.Match does work more as nearly all users would expect, is there some reason Application.WorksheetFunction.Match can't work exactly the same as Application.Match? If not, why can't Application.WorksheetFunction.Match work exactly the same as Application.Match?
2 votes -
VBA Programming language lacks syntax for sorting and compressing 2 dimensional array variables
Sort arrays both single and two dimensional as well as being able to groups and sum array elements. As arrays run 20x faster than normal VBA code this would make programming fast running macro's much easier.
6 votes -
There should be a Worksheet.RowCount and Worksheet.ColumnCount properties that tell you what the last row or column with data is
There is no good way of finding the last row or column with data in a worksheet.
Three ways are of finding the last row or column are:
1) used Worksheet.UsedRange. The problem with this is that if some of the cells in the range have had their contents cleared or deleted then they are still considered in the UsedRange. this means that the bottom-rightmost cell in the UsedRange may not have any data in it and cannot be accurately used to get the row or column count for the worksheet.2) Using range.end(xlup).row or range.end(xltoleft).column only works for a…
95 votes -
VBA Forms not working in MS Office 365 ProPlus version 17.0
VBA Forms not working in MS Office 365 ProPlus version 17.0 which got released recently on May 9th, 2017. The Macros are getting crashed throwing the error 1004: Application-defined or object-oriented error. Until Version 16.0, Macros worked fine.
2 votes -
Create 64-bit compatible versions of MSComCtl and MSComCt2 controls
We have been advised to consider upgrading to the 64-bit version of Office throughout our company. As a world leading financial institution we have a lot of users that use Excel applications that require large amount of memory and processing power.
We have a dedicated VBA development team that make extensive use of the controls and we need 64-bit versions of the controls before the roll-out can go ahead as a large number of critical applications will no longer work in 64-bit Excel.
216 votes -
DON'T use Python as an Excel scripting language
DO NOT let us do scripting with Python! Yay!
11 votes -
VBA refer to powerquery connection without loading to table
Would it be possible to access the powerquery connection without loading the data to a listobject?
I was looking at automating an extract of online data, which was in JSON format, this is a hassle in VBA but pretty manageable in powerquery (get & transform).
So I thought maybe I could write a UDF to set up the power query connection, get the data, and output the relevant information. But it seems the only way to "access" the power query data is to load it to a listobject?
It would be really nice if this wasn't a necessary step to…
4 votes -
Office 365: Sync add-ins between computers
As of Office365/2016, Microsoft has delivered a good number of invaluable add-ins for use with Excel, Word, or PowerPoint.
But if you use multiple computers (3 in my case) it can become pretty tedious to install the add-ins on each of them as you have to do it manually, while connected to the internet.
It would be really nice to have an option to synchronise all Office add-ins across the computers related to the same Office account.
Thus, you could save quite a bit of time and also be sure that the add-ins are there for you when you need…8 votes -
Modify the stock analysis template in excel 2016 to allow those stocks listed on Yahoo.Finance
Modify the stock analysis template in excel 2016 to allow those stocks listed on Yahoo.Finance. For instance, I cannot add D05.si
8 votes -
Intellisense for User Defined Functions
Currently User Defined Functions (UDFs) in Excel will not show intellisense to tell the user what arguments need to be supplied. This makes them very difficult to use.
There's a discussion here:
http://stackoverflow.com/questions/16903587/the-quest-for-the-excel-custom-function-tooltipWhether the future of UDFs is in VBA or something else, the ability to define intellisense is vital.
298 votesThanks for the suggestion Nick. We’ve got some related work we’re looking at soon, and we’ll be sure to carefully consider if we can get a fix in for this then. As always, more votes helps – so keep voting for the things you care about most.
Thanks,
John [MS XL] -
There should be an event when an AutoFilter is changed
There is currently no event when an autofilter is changed. The autofilter could be in a normal range or in a table.
The current workaround is to create a hidden sheet with a formula that references the cells on the sheet with the autofilter and to catch the WorksheetCalculate event in order to know when someone changed or cleared an autofilter. Additionally for this to work, calculation must be set to Automatic. http://stackoverflow.com/questions/28979396/excel-vba-filter-change-event-handler
44 votes -
Add the ability to hide columns in the Power Query Editor
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....
10 votes -
Range.Text should be able to return an array of results like Range.Value
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).
36 votes -
Fix errors and incompleteness in macro recording
The macro recorder is a highly valued feature of Excel and is used by novices to generate code to automate repetitive operations and by more expert users as a quick way to confirm the appropriate properties and methods to use to achieve a desired effect.
There are some operations that the macro recorder does not record at all and others which it records incorrectly. This suggestion is that all such errors and omissions should be fixed when they are identified.
The latest to come to my attention was assigning a formula to a shape, to link its text to a…
23 votes
- Don't see your idea?