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. Add oMath capability through VBA, add cell links

    Allow the programmatic creation of equations through VBA. The oMath API is already incorporated in MS Word. If cells can also be referenced in the Equation Editor/oMath, this would be a "killer feature" that would help compete with programs like Mathcad.

    In engineering applications where showing calculations is important, it is tedious to put manually assemble equations in the Equations Editor that match a formula, then show a formula with values used before showing the calculated result. Adding oMath into VBA and allowing cell links would go a long way to reducing this overhead.

    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 →
  2. Need a macro shortcut key manager

    Please create a macro shortcut key manager! Right now, I have no way of knowing if Ctrl+k has been assigned to a macro, or what macro a shortcut key is assigned to (i.e. both directions are unknown). It would be very nice to have a table that you could edit and track down what macro shortcut keys you have assigned to what macros. I consider not having this utility a bug.

    7 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 →
  3. View vba code in protected view

    When a file is in protected view, i can't see the vba code in the editor. This is rather impracticale since it makes it impossible to determine if it is safe to disable protected view for that file.

    10 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 →
  4. Formulas for Analysis Toolpak Regression tool & similar hard-coded add-in outputs

    The Analysis Toolpak Regression tool outputs some very useful data. However, the outputted values are hard-coded. We cannot tell how each was calculated or precisely what data was used to generate the output sheet. It will also not update to reflect new data.

    There are tutorials online explaining how to reproduce the output using formulas:
    http://www.real-statistics.com/multiple-regression/multiple-regression-analysis/multiple-regression-analysis-excel/
    http://people.clarkson.edu/~wwilcox/ES100/regrint.htm

    However, these would not be necessary if Excel just did it all for us. After all, it knows how it is calculating everything, so it might as well show its work. The same can be said for any other tool in the toolpak…

    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 →
  5. Enable standard resizing ability for forms

    Enable forms to be resized by dragging the edge of the form instead of requiring custom VBA code to be written in order to resize custom forms.

    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 →
  6. Macro Relative Reference Option More Visible

    When recording a macro using the Use Relative References option, the change in the icon is too subtle to easily tell if the option is active or not. Instead of the very faint border around the icon, make it more evident when the option is active or inactive.

    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 →
  7. Lookbacks in Regex being supported

    Currently, with VBA's reference of "Microsoft VBScript Regular Expressions 5.5", lookbacks aren't supported. The only way to mimic a poor lookback is to use grouping, and have a partial lookback before the grouping. For example:

    LookbackPortion(The Group we want)

    While this works for some cases, it in no way comes close to being a proper implementation of a lookback.

    Currently there are many requests for Regex in Excel. Currently, it's fairly doable with a short user-defined function.

    So the request is to properly implement regex lookbacks in VBScripts

    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. Defining a subset of the possible VBA commands usable without triggering a security prompt

    Might allowing the use of a subset of VBAs commands (enforced by the virtual machine) for certain projects allow for a reduction in the need for security prompts and help prevent users becoming accustomed to clicking enable when opening a spreadsheet without thinking of the consequences. I.e. certain spreadsheet could be tagged by the developer as only using this subset of VBA commands and could run without the need to trigger a security prompt.

    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 →
  9. Macros - Make it simple to transfer macros and PERSONAL workbooks, and combine multiple PERSONAL workbooks on one computer.

    Macros - Make it simple to transfer macros and PERSONAL workbooks, and combine multiple PERSONAL workbooks on one computer. This is ridiculous. I use multiple complex macros. Make it easier for regular people to do!

    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. Excel Forms as addin

    I suggest that the Excel Forms which are available only in online version (i think 2019) are also to be available in Excel 2016 desktop version and have support of 1drv will strengthen it.

    It could be as an addin downloaded from microsoft.com

    This may process like; first download the addin,
    then add to Excel,
    then on this addin ribbon provide a microsoft account,
    then use the form for Quiz Survey etc,
    notifications like user submissions will be displayed in ribbon,
    the data will be downloaded by selecting specific quiz/survey.

    Also can active, inactive, copy or delete the quiz/survery.

    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. Add SharePoint and Onedrive OAuth authentication in VBA

    Currently I use rest with SharePoint and Onedrive, but in VBA this is not very easy and can sometimes be troublesome.
    Like in the newer languages (e.g. C#) authentication can be done in a few lines of code and it would be good to have some thing similar built into VBA.

    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 →
  12. 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 →
  13. Allow UDF's to work if macros are disabled.

    If a macro is marked as a UDF, it would be available even if macros have been disabled if a user so selected either as a general option or when opening a spreadsheet.

    Any so marked macro (UDF) would be limited to no work outside itself except to provide its result to the cell it is used in and could only use inputs specified in its use. No other externalality could be done: no accessing non-specified cells/range/etc. for any reason, no actions like changing window size or deleting files or whatever. It could only use its defined-in-the-cell inputs and only…

    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 →
  14. Prevent windows from doing a restart when a program is actively running in Excel

    I have a number of very large number crunching models that are run by macros and often take several hours to complete with my core 5 computer. I set these up to run over night or during the day when I am out or working on other things. When Windows decides that it is time to do an update it simply closes Excel even though it is very busy crunching numbers. Today I lost three hours of work because it does not even bother to save the file since it only does that when the program is sitting there not…

    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. Support trusting publishers for certificates used to sign macros on shapes.

    When macros are signed with a certificate, the user is given the option to "Trust all documents from this publisher". However, this option is not available when the signed macro is attached to a Shape.

    This behaviour should be consistent no matter where the macro was attached.

    See attached "failbook.xlsm" and "successbook.xlsm". Failbook has a macro attached to a shape, successbook has a macro attached to a form button. The images "macrooptionssuccessbook.png" and "macrooptionsfailbook.png" show the differences in the macro options screen between the two excel workbooks.

    Reproduction steps:

    1.-In the Excel Trust Center, enable "Disable all macros with notification"

    15 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. Allow UDF's to work if macros are disabled.

    If a macro is marked as a UDF, it would be available even if macros have been disabled if a user so selected either as a general option or when opening a spreadsheet.

    Any so marked macro (UDF) would be limited to no work outside itself except to provide its result to the cell it is used in and could only use inputs specified in its use. No other externalality could be done: no accessing non-specified cells/range/etc. for any reason, no actions like changing window size or deleting files or whatever. It could only use its defined-in-the-cell inputs and only…

    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 →
  17. Automatically Create Macros when user does repetitive task

    Some macros are difficult to make and hard for intermediate and beginner excel users. For example, I am removing duplicates in groups only separated by a small heavy border line in one of the cells. This should obviously be possible to automate, but for this application it is faster for me to do it manually than learn how to make the macro.
    Hence, automatic macro creation. It would be a genius invention and bring excel into 2020.

    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 →
  18. powerpivot, bring it back.

    Bring back PowerPivot

    5 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 →
  19. Code module comparison tool

    Due to a number of factors (I started having this problem mostly after our company implemented OneDrive, but I'm sure there are complementary factors like intermittent network connection, etc) I keep having Excel restart or reconnect in ways that it has to recover files including personal.xlsb.

    For most "front-end" files, I can just open the most recent one from the recovery panel, and move on. However, when Excel re-opens it does so with personal.xlsb loaded, and I haven't managed to figure out how to tell Excel "only use the most recent [recovered] copy". So these backup copies get stored/saved, and…

    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 →
  20. Make Macros easy to copy and paste into another computer

    I want to record a macro, create a button on my excel worksheet, so it is available to run whenever I want to run it. AND make it easy to copy so I can share it with friends and put it on my laptop without having to physically re-record it. ( export data out of our software into an excel workbook and then I want to run my macro on that data. It's difficult because you cannot edit that macro if you want to change something. Also, I cannot move it to my laptop, nor can I give the macro…

    4 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 →
  • Don't see your idea?

Feedback and Knowledge Base