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. 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()

    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 →
  2. Money in Excel - Import Transactions

    In Money in Excel, it would be nice to have the option to import transactions. I have transactions I would like to include in my spreadsheet, but they aren't able to be imported via Plaid.

    26 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 →
  3. Make it posible to attach a template to the Empty Workbook-option on the Start Screen and File, New

    In previous versions of Excel you could create a Book.xlt and make that the default template for new workbooks by saving it in the XLSTART folder. That does not work with the Start Screen/Back Stage in Excel 2013 and 2016 which makes it imposibole to provide customers with a custom template for new workbooks with customized colors, fonts etc. Please make it posible to attach the Empty Workbook option to a customized template. (It still works in Word 2013)

    25 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. Keep the font color white on the Status bar while macro is running, so users can read the feedback displayed there.

    When running a macro, it helps to turn screen updating off to maximize speed. Also, users want to know what's happening, so a very good way to do that is to output a progress message on the status bar, such as the process completion percentage...

    New in Excel 2016, the status bar font turns dark grey on a dark green background when the macro is running, making the messages there unreadable. Why? Earlier versions of Excel did not have this design flaw. I understand that different windows themes can be tried to avoid this, but as a developer I can't…

    23 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 →
  5. 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 →
  6. 22 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. More vba events

    VBA events are extremely powerful but currently they are seriously lacking! If the Excel team went through and exposed more events VBA would a lot easier to manage for complex applications.

    Events to expose:
    * Row and column insertion
    * Table specific events:
    Table - Insert_Row
    Table - InsertColumn
    ** Table - Cell
    Change
    Table - On Filter
    Table - On Filter button click
    * Chart events!
    Chart - On Mouse Down
    Chart - On chart object select
    Chart - On chart resize
    * Shape events
    On shape resize
    On shape click
    * Comment events
    On Comment Edited
    On

    21 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 →
  8. There should be a WorkbookAfterClose event

    there is a WorkbookBeforeClose event but there is no corresponding WorkbookAfterClose event.

    Note that the WorkbookBeforeClose is cancelable so there is no guarantee that the workbook will actually be closed after that event is triggered.

    Currently in order to get the WorkbookAfterClose event, a workaround needs to be implemented: https://exceptionalcode.wordpress.com/2010/02/11/how-to-get-an-excel-vsto-workbook-closed-event/

    20 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. Get status of WorkbookQuery (Power Query) in VBA

    Could you please consider possibility to add new property to object WorkbookQuery, that return status of query result. E.g. "N rows loaded", "Load to Data Model failed.", "Connection only".
    Currently I do not see option to catch query refresh issue in VBA.

    18 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 →
  10. Worksheet protection - UserInterfaceOnly setting should maintain between workbook openings

    When developing VBA and/or VSTO solutions for Excel, you might come across the problem that a protected worksheet where the UserInterfaceOnly parameter was set to "True" cannot save its state to the next Excel session. This means that the UserInterfaceOnly setting cannot be maintained between workbook openings. Therefore, to re-establish the setting you have to unprotect and re-protect the specific worksheet (for example during the Workbook_Open event). Unfortunately, since Excel 2013 this might be a performance issue when handling a lot of worksheets (see https://msdn.microsoft.com/en-us/library/office/ff837594.aspx?f=255&MSPPError=-2147217396#xl15WhatsNewProtectingsheets - "Protecting Sheets takes longer"). On a modern desktop computer you would probably not even…

    18 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. Improve VBA protection

    it is not a secret that the VBA protection password is very weak, it is very frustrating that I can't defend properly a sensitive code in the one of the biggest and popular software (Excel) in the world.
    improving VBA protection is a game changer for lots of people.

    17 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 →
  12. Improve *Workbook.RefreshAll method

    Please consider updating method RefreshAll of Workbook object by adding return value to it.

    At least return 'true' when refresh went successfully, 'false' when not.

    Currently, VBA ignores appearing during refresh of connections errors. However, when such refresh is triggered manually by pressing menu button (tab Data -> Refresh All), Excel shows message and a proposal to cancel refresh of remaining queries or continue.

    Description of problem can be also found under following links

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8f028b00-36c7-40b7-b363-07e056cbbcc6/thisworkbookrefreshall-does-not-throw-error-but-refresh-all-in-data-tab-shows?forum=sqlkjpowerpivotforexcel

    https://www.mrexcel.com/forum/excel-questions/1021642-vba-error-handling-activeworkbook-refreshall.html

    Thank you!

    17 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 →
  13. vba userforms

    Please provide more controls on forms to improve its look and feel. 3D effects, animations on buttons, table formatting in text boxes, etc

    16 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 →
  14. 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 →
  15. Change Significance F Label in Regression Output

    My MBA cohort is having a difficult time remembering that Significance F is really the model-level p-value. We understand that the p-value labels below refer to the individual variables, but Significance F is obscure.

    I suggest that you change the label Significance F in the ANOVA section of the output to Model p-value to resolve this confusion.

    14 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 →
  16. Adding WorkSheet.BeforeChange event in Object Model

    Worksheet Object does not fire a Worksheet.BeforeChange or Worksheet.Changing event. For our use case, which is for auditing and potentially preventing changes done to Excel Sheets by specific users, we get the event after things have changed.

    We have a specific set of cells that should changeable by only a few users so we use .net interop to get user credentials from Active Directory.

    14 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 →
  17. auto indent and group VBA code

    There are several compilers in other languages ​​that allow the self-indentation of code and the grouping of code structures to make it more readable. Please, improving this part in VBA would be very interesting. Blessings!

    13 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 →
  18. Export the results of Spreadsheet Compare as a spreadsheet with highlighted differences instead of a list of changed cells

    In the former version "Essential Spreadsheet Compare 1.34.8" the comparison gives you an output where you have in the same spreadsheet the changed rows in red with a strike on top and the new ones in green . This allows users to identify the changes maintaining the view of the whole row and to easily replace the old by the new rows and keep a tracking of the changes.
    In the new version you just have a list of the cells that changed and what changed. Although the program shows you a spreadsheet with the differences highlighted it does not…

    12 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. Improve Excel's ability to locate, edit and break links in spreadsheets.

    Often I create spreadsheets used by others within my company and by some of our business partners outside of our company. This may involve merging multiple spreadsheets into a single larger spreadsheet. Under these circumstances it is common to have the new merged spreadsheet pulling something from one or more of the previous stand alone spreadsheets. It works fine on my company laptop as I have access privileges to all of the previous stand alone spreadsheets. However when I give the merged spreadsheet to others within my company and/or our business partners they may experience linking problems. The more knowledgeable…

    12 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. Adding an UNDO feature to Excel VBA

    Hey There,

    There is no doubt that VBA is offering great solutions for companies and individuals. I have been working on VBA extensively for a year and the only thing that is still illogically unresolvable is the UNDO feature to VBA Excel.

    I would really appreciate it if it possible to point out why it is not possible to add such a thing to EXCEL VBA.

    Thanks in advance.

    12 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