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. Make "Function Arguments" dialog box work properly for all VBA functions

    I use Excel 2013 and for long VBA function definitions I get "(...)" displayed for function arguments, bur the function is still callable from a sheet.

    I think that this dialog box should "work" for all valid VBA functions.

    The same applies to the "Insert Function" dialog box.

    7 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. Date macro is recorded. This used to be automatic when recording a macro, now it's gone

    When recording a macro, the header of the macro used to automatically place the date. This was a really nice feature to know when the macro was recorded. Not foolproof but really nice. Now that feature is gone. Can you put that feature back please!

    2 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 →
  3. copy / insert issue

    Hello Excel User Voice,

    I have a macro that worked fine for over a year, but after the latest Office update something changed and the macro behaves differently.

    Initially, I thought that it was the Insert method that changed, however, having tested this now i can see that it's the Range.Unmerge method that behaves differently.

    We have users with three different Office builds in the team:
    1. 16.0.4498.1000
    2. 16.0.7329.1054
    3. 16.0.8201.2075

    For users on build 1 and 2, Range.Unmerge method unmerges the cells AND clears contents of clipboard AND/OR sets the Application.CutCopyMode to False.

    For users on build 3…

    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. Version 1705 Undocumented VBA Language Changes

    As you can see by many posts, we developers heavily utilize VBA. As versions change and items are removed, we have to adapt our macros accordingly. Most of the time major changes in the VBA language happen at major version upgrades (e.g. 2007 to 2010 to 2016).

    Recently Version 1705 started to be pushed out to people. I have a simple bit of code that enables the events for all workbooks that open. Prior to Version 1705 it worked perfectly, but now it fails on the variable definition. (Dim x As New EventClassModule now gives an error - "Compile error:…

    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 →
  5. Unique instances of excel please....

    ...without having to do this...press Windows+R (Run), then type “Excel /x” without quotes. This is not efficient

    3 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 →
  6. Optimize an quotient with Solver Add-In

    The ability to optimization an quotient for example for indicators of profitabilty, economic and so on from companies.

    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 →
  7. add language independence, AI help, and GUI Web services with Intellisense to macros

    The macro recorder & editor can be improved on by giving the user the ability to change the macro's programming language, on the fly, while editing. The macro editor should have a built-in language converter.

    Before you say it can’t be done, remember that we are at a point where AI is evolving so fast that the “can’t be done” list is evaporating before our very eyes, every day. Also, if Microsoft is indeed ‘Infusing AI Into Every Product and Service’ It Offers:

    https://www.seeker.com/tech/artificial-intelligence/microsoft-is-infusing-ai-into-every-product-and-service-it-offers

    then why not programming itself?

    So back to the improved macro language converter, I would recommend…

    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 →
  8. Create a Worksheet.BeforePasswordChange Event for .NET and VBA

    Worksheet security is pretty weak. It would be great if there was an event available that listened for password changes and ran any applicable code before the worksheet password was changed. This would allow developers better security around worksheets.

    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 →
  9. Add a workbook property that we can set at design time to force user to enable macros

    If a workbook is reliant on macros or user-defined functions, developers often want to force the user to enable macros when they open that workbook. Current practice is to hide every worksheet except one displaying a nag to enable macros. We then use a WorkbookBeforeSave and WorkbookAfterSave event macro to do the hiding and unhiding of worksheets to make sure the nag message is displayed only when desired.

    If we had a property we could set at design time to force the user to enable macros--or else the workbook wouldn't open, we would eliminate almost all the use…

    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 →
  10. Update the visual basic UI

    Still looks like Windows 95 UI.
    Please update the UI

    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 →
  11. Add a VBA Property for ProtectSheet / UnprotectSheet that selects hash method

    See the thread: https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msoother/excel-2013-is-very-slow-in-loading-large-workbooks/3dc258b1-0d9b-492c-8ab8-2ba1df26fc7e. Be sure to read my post: DennisAd replied on February 26, 2017.

    Bottom line:
    1. SHA-512 hash for Worksheet Protection makes VBA that turns protection on/off really slow
    2. There is no additional security provided by SHA-512, since the worksheet info is stored in-the-clear on disk.
    3. All the code to support older (FASTER) methods is still there.

    Details in the thread,

    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 →
  12. 2 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 →
  13. 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…

    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 →
  14. VBA, get the range marked to copy (or cut)

    When user select and mark range to cut/copy, in VBA exists Application.CutCopyMode to check if there are some range to cut/copy. But I need some property that return this range (Application.CutCopyRange)

    2 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 →
  15. VIsual Basic Editor to remain on current code window when existing .xlsm file opened.

    When one is working on a procedure in the VBE and another .xlsm file is opened, the code window automatically changes to a module in the newly opened file. This is annoying when one is writing code and opens a different file to refer to it for some reason. Ideally the module shown in the code window should remain as it is. Alternatively place an option in Tools | Options ... for the user to select their preference.

    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 →
  16. 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…

    6 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 →
  17. Activeworkbook.close falsely triggers Userform QueryClose Event with CloseMode=5 (undefined constant!)

    I have a Macro along with an Userform attached to an excel sheet. When the macro get executed, it will Open several workbooks and does some manipulations based on the Userform input and closes those (Userform will be hidden throughout the process once the user given data). But when command Activeworkbook.Close is executed for the first workbook, QueryClose Event in the userform section triggers.
    Specially this happens in Excel 2013 (VBA 7.1) and not in Excel 2010 (VBA 7.0) Please debug this issue...
    Reference:
    https://social.msdn.microsoft.com/Forums/en-US/14edc442-f380-47db-af96-317ca06d37ef/queryclose-event-triggers-when-activeworkbookclose-command-executed-in-excel-2013-vba?forum=exceldev

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

    We’ll send you updates on this idea

    5 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. Trigger an event when plus/minus sign on Outline Symbols bar is clicked

    Currently, it is impossible to detect when a plus/minus button within Outline Symbols bar is clicked. It would be nice to have this functionality introduced.

    There are already events that are capturable using Ribbon XML that serve similar purpose: OutlineShowDetail and OutlineHideDetail.

    However, those events are triggered ONLY when Show/Hide Detail buttons are clicked within Data Ribbon. They are NOT triggered when plus/minus sign is clicked.

    More details:
    https://social.msdn.microsoft.com/Forums/en-US/c1a9400a-486a-4b3a-9cb0-47ad04b08bf2/triggering-outline-hide-detail-event-clicking-minus-sign-on-outline-symbols-bar?forum=exceldev

    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 →
  19. 4 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 →
  20. Fix object model implementation of Top10 Auto Filters

    The current implementation of the Top10 auto-filters in Excel is horrible.

    There are four 'Top 10' filters: xlTop10Items, xlTop10Percent, xlBottom10Items, xlBottom10Percent

    Problem 1) The names are deceiving. They are not always 10 items or 10 percent. Better names would be Top X Items or Top N Items.

    Problem 2) The Excel object model does not allow the original criteria to be retrieved. If you create a Top 10 Items filter with the value 15, then the Filter.Criteria1 property will be changed to a >= criteria depending on the data in the column and the original value of 15 has no…

    7 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