Feedback by UserVoice

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Python as an Excel scripting language

    Let us do scripting with Python! Yay! Not only as an alternative to VBA, but also as an alternative to field functions (=SUM(A1:A2))

    6,287 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    436 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Wow.

    Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.

    Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.

    We’ll provide updates as we progress on this feature request.

    Thanks!

    Ashvini Sharma
    Lead Program Manager
    Excel

  2. 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-tooltip

    Whether the future of UDFs is in VBA or something else, the ability to define intellisense is vital.

    256 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks 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]

  3. update VBA

    It would have a couple of stages.
    Stage 1: Get Visual Studio features into the VBA development environment.
    Stage 2: Fully integrate VBA into Visual Studio.
    Stage 3: Continually improve VBA until it is a modern language.

    Notes:
    VBA is probably the most used programming language in the world.
    It has so many established users that MS could really get big brownie points by continually improving the experience for users and developers. Why it has stagnated for so long I have never understood.

    I have seen your response for the above posted previously and you are missing a major point.…

    230 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    14 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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.

    181 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    22 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  5. R in Excel (RRO + MKL as scripting language in Excel)

    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.

    145 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Accepting Votes  ·  21 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  6. Integrate VS Code into Excel, at the same level as the VBA IDE

    VS Code has an equivalent feature set to the VBA IDE (editor with Intellisense, syntax highlighting and validation; debugger with locals and watch panes, code navigation). Leveraging VS Code for editing and debugging macros embedded in Excel documents would bring the following benefits:


    1. Excel could support embedded scripts in various languages (https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10549005-python-as-an-excel-scripting-language), as long as the language is supported in VS Code (Python, R, Javascript) without needing a new editor for each one (both a maintenance burden, and a profusion of UIs for the same task of editing and debugging code).


    2. The only VBA IDE features not available…

    114 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    32 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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…

    89 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    8 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow Excel Macros to be written in PowerShell

    Allow Excel Macros to be written in PowerShell.
    It would also be amazing if it could be used as an alternative to field functions such as "=PRODUCT(A1:A10))"

    I believe that Microsoft Excel naively supporting PowerShell as a 21st century alternative to VBA would be the most beneficial change made to the software since release.

    Almost all Microsoft products are becoming PowerShell integrated, yet Office remains only supporting VBA.
    VBA is an archaic procedural language which despite its ambivalent love from the community, seems to have little to no place in the modern world.
    PowerShell can directly interact with COM objects…

    85 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  9. VBA ScreenUpdating-Property does not work in Excel 2016!

    The VBA Application.ScreenUpdating-Property does not work properly in Excel 2016 / Win 10. See attached screenshot. The screen is updated after each step in VBA, although the ScreenUpdating is set to False. The property worked nicely in Office 2007 / Vista.
    It would be nice to have this bug fixed as quickly as possible, since I have hundreds of Makros who depend on this property.
    Christian Klug
    Düsseldorf, Germany

    83 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    55 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  10. Create a command line tool for signing Office files with a digital certificate

    Besides Office, Excel files can be created using numerous software tools. More often than not, batches of macro-enabled Excel files are processed with scripts for productivity purposes. However, VBA code signing cannot be part of an automated process, as it is a manual task that requires opening & saving the file in Excel.

    This request is about creating a command line tool for signing Office files with a digital certificate, similar to MS SignTool.

    In addition, the existing macro signing process in Office is not 100% compatible with Open XML specifications. I can clarify this statement in a private discussion…

    82 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    23 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  11. Please support Unicode font in VBA

    Please support Unicode font in VBA.

    Thank you!

    64 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  12. Expose more events in VBA

    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.

    55 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  13. C# as a scripting language

    Let us code macros directly in C#!

    45 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  14. 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

    42 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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).

    35 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add VBA Support for Excel 2016 charts like Waterfall, Pareto etc

    Please add VBA support for new Waterfall, Pareto, Histrogram, Treemap, Sunburst and Box & Wisker chart types. Specifically, include the ability to record a macro when operating on new charts and provide corresponding Excel VBA Object library nomenclature. There is currently no VBA support for new Excel 2016 chart types, making it impossible to automate and include them into existing toolsets. Waterfall chart support is a priority. Thanks!

    34 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  17. 32 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. Remove the 255 character limit in Excel object model functions

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

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

    26 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  19. Update Visual Basic for Applications

    Visual Basic for Applications is still version 7.1 from 2012. It's high time that power user portion of the application received updates to the interface, IntelliSense, and features. That portion of the program needs to be aligned with the current features now available within the Microsoft Suite. It also needs a facelift to the Userforms palette. I suggest starting with Excel, where VBA is most widely used, then PowerPoint, Word, Outlook.

    Don't go destroying developer's programs, just add interoperability, functions, and facelift.

    24 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  20. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 12 13
  • Don't see your idea?

Feedback and Knowledge Base