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. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  2. Give VBA some love -- Easy ribbon additions

    The beautiful thing about VBA is that it can be easily used by END USERS. Not professional programmers.

    Adding a simple button to the ribbon required pulling apart XML files which is NOT end user computing.

    Some simple mechanism to add buttons would be helpful. Need not be complete, just a way of recording a macro and then running it easily. Cannot be done at present.

    (And of course, the ribbon should have an object model like everything else. But that is too much to hope for.)

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

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  3. Excel macro web & app

    We can't convert an excel macro with activex into web.
    If i'm right web and app are the next steps in excel. We must have clear option to convert excel macro with activex and other add-ins into web page and android app.

    This will boost the excel to high level. Please consider this request

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

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  4. VBA error object to include line number/text property

    VBA Error object should have properties called line Number and line text which will let us know the line number of the code and the line text of the code where error occurred. This will help us very much in case of offline troubleshooting through logs

    5 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 →
  5. freeze panes via VBA without needing to activate the sheet

    in VBA there is no way to split & freeze a sheet without Activating the sheet first.

    Most tasks can be programmed to change a sheet without the sheet being Activated.

    So, please provide a means to add/delete/control split & freeze panes programmatically in VBA without the need to activate the sheet first.

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

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  6. While it is much better than past versions of Excel that used a macro to calculate a histogram, the new histogram chart creates this chart f

    While it is much better than past versions of Excel that used a macro to calculate a histogram, the new histogram chart creates this chart for you. However, unlike the older implementation using a macro, the new chart does not give me direct access to the underlying numbers to allow me to normalize them or to be able to change the bin sizes to be unequal sizes, i.e. 0-1, 1-1.5, 1.5-3, 3-4, etc. I have lost flexibility at the expense of simplicity.

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

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  7. Insert add-in from URL

    Commonly we use github or gist to store add-in tests etc.

    It'd be great to be able to use the HTML and XML manifest on GIST for our Office add-in for example! Similarly in general, it'd be great to just be able to update 1 website which will update all add-ins. This is already basically how office addins work anyway, but it'd remove the requirement to have a remote network. You could also use file URLs which is nice for when you don't have internet!

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    32 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 →
  9. VBA is a bit old fashion & difficult to use compared to C#. i dont expect VBA to be as comprehensive as C#, but some improvemt wld be nice.

    VBA is a bit old fashion & difficult to use compared to C#. i dont expect VBA to be as comprehensive as C#, but some Improvement wld be nice.

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

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  10. Include "Run to end of current procedure" option in the right-click menu (in VBA Editor).

    Occasionally, when going step-by-step through a macro, I step into a (lengthy) procedure, that may be trivial or 'known good', and doesn't require review, though I now only have 2 options - to continuing stepping line by line, or running the whole thing without breaks.

    As this is unintentional, the (current) solution is to simply scroll to the end of the procedure (i.e. the end sub/function line) that I have stepped into, and right-click and click on "Run to Cursor". However, this is an unnecessary and laborious, especially if the procedure is long.

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

    We’ll send you updates on this idea

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

    82 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 →
  12. As policy, all apps/add-ins endorsed by Microsoft should have capability of being disabled by the user.

    Stock Connector is an Excel add-in that can't be disabled by the user once it's installed! It can be "removed", but not "disabled". One would think that, as a matter of policy, Microsoft would check all apps and add-ins to ensure they can be disabled by the user prior to authorizing their sale on the Microsoft Appsource or store.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  13. Actually read some of these suggestions, and provide comments to show you have

    I have a strong suspicion that these comments are never read. That they are just there to make people feel they can engage. If so that is an insult to the people that take the trouble to comment here.

    Some feedback would make us feel listened to.

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

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  14. Excel Forms: Bringing the useful icon sets to the form design tool box.

    Icon sets available at the insert/ilustrations user interface would become even more useful if added to the form design tool box for excel scripting developers, so commands can be associated with an icon, on its own, or next to an activation button.

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    28 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  16. Solver Parameters dialog

    UNCHECK "Make Unconstrained Variables Non-negative" as this option isn't the standard case.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  17. Make the keyboard shortcut Ctrl+G close the Immediate window in the VBA editor

    In the VBA editor, when I press Ctrl+G to open the Immediate window I expect the Immediate window to close when I press it again.

    I suggest making this keyboard shortcut works as a toggle button to open and close the Immediate window.

    We currently don't have any way to close this window except pressing the exit button.

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

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. formulaarray

    It is well past time to remove the 255 character limit on a range object's FormulaArray property

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

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow Lua for scripting instead of VBA

    I know the Python scripting idea has 5000+ votes. But if it's decided that Python is too heavy weight for scripting in Excel please consider Lua. It's small, modern and lightweight and built for this exact use case, to be embedded into larger programs and be used as a scripting interface.

    https://www.lua.org/

    3 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 →
  20. (easier) method to debug.print an array (1D, 2D, or 2 selected dimensions)

    I'm currently debugging some code, and have several arrays where being able to see the full array of values at specific points in runtime would be immensely helpful in my troubleshooting.

    I'd like to suggest that rather than having the user write code loops or lines to print out an array in a table format
    for I = 1 to 10
    debug.print (array1(i,1) & " " & array1(i,2) & " " & array1(i,3))
    next I

    it would be awesome if the VBE had a built-in function that would debug.print an entire 1D or 2D array, AND with an optional parameter…

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

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base