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. start using C# as the macro language instead of visual basic

    well, visual basic great language loves it but Microsoft seems to have abandoned the language. C# is clearly the new emphasis so, therefore, start the move to make C# the default language for the office products. plus there is an opportunity to increase the performance and features of the macro language. allowing for the creation of exportable modules and even binary macros that run faster or can be more easily exported to different machine

    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 →
  2. Associate formulas to mouse button

    Like in videogames in which you can set several shorcuts attached to your mouse buttons. It would be really great if i could associate a formula to one button instead of writting or copying it all the time.

    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 →
  3. Excel VBA 2001-12425 UserInterfaceOnly:= True has partial effect on letting Macros change protected sheets

    Reference a previous suggestion, https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/11050386-worksheet-protection-userinterfaceonly-setting-s , the VBA function seems to be broken. Although set for specific worksheets at Workbook_open, macro execution get blocked on relevant sheets because protection is set. The password is uniform across the workbook, so still needing to execute a slowing unprotect, which risks the sheet become accessible for modification if the relevant macro fails.

    Oddly, unless the UserInterfaceOnly is set during Workbook open, the ,UserInterFaceOnly:=only is declared illegal in the relevant module while reprotecting the sheet during code compiling.

    Edit: Specifically, of the various cases, a Run-time Error '3000' occurs when working with tables on…

    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 →
  4. ASC statement: If ASC(CHAR)>97 and ASC(CHAR) <122 THEN – doesn’t work

    ASC statement in EXCEL VBA_365, doesn’t work.

    Dim CHAR As String ‘’’ (One character String variable)
    If ASC(CHAR)>97 and ASC(CHAR) <122 THEN ... – doesn’t work.

    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 →
  5. Add Worksheet_Before_Calculate event to VBA

    Add an event that will trigger before calculation takes place. This would enable commands like Application.RTD.RefreshData and other updates to occur prior to the workbook (or worksheet) calculation occurring.

    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 →
  6. kindly include data mining add ins in the all versions of excel

    include data mining add-ins in all versions of excel

    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 →
  7. Fix macro glitch in excel

    My corporate computer was recently switched to Office 2019. Excel was opening just fine for me until I created a macro - now I'm getting a notification "personal.xlsb is locked for editing". I've tried the "share" option which allows me to unhide my personal file and enable my macro, however, upon closing and reopening excel, I get the same error message and have to go back and do this process again to enable the macro. There has to be a fix for this - I shouldn't have to go through this process every time.

    1 vote
    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 →
  8. Create reading layout addin

    Create reading layout addin

    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 →
  9. Please add power pivot option for Microsoft Office Home and Student 2016

    Please add power pivot for Microsoft Office Home and Student 2016. It would be much helpful

    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 →
  10. 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 →
  11. Incorrect formula for standardized residual in the regression data analysis tool

    Currently, the standardized residual in the regression data analysis tool is calculated as the residual divided by the standard deviation of the residuals.
    This is incorrect.
    Notwithstanding the fact that the correct standardized residual should account for leverage (this is actually called a studentized residual in some schools of thought), you should at least modify the formula for standardized residual so that it divides the residual by the standard error of the estimate, which is also called RMSE, instead.
    The difference is that the standard deviation of the residuals is calculated as:
    SQRT(SSE/n-1)
    Whereas, the standard error of the estimate…

    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 →
  12. SaveCopyAs

    Workbook.SaveCopyAs works only for the Old Excel Formats (<=2003)
    Does not work for .xlsx, ,xlsm, .xlsb

    Please upgrade to this to work for New Excel Formats (>=2007)

    Sam

    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. Encoding of a string value

    My problem is: I am getting Hungarian text from a textbox of a userform. If the text has some special Hungarian characters, like á, é, Ő, Ű, etc and I print out this string, I can not use it with another program, which expects encoding UTF-8
    Can I somehow change the encoding of a string value in a VBA macro?
    (I am using Office 365 on Windows 7 and Windows 10 operating system)

    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 →
  14. AutoFit columns in the output sheet of the Analysis ToolPak's Regression tool

    Currently, many cells in the output sheet of the Analysis ToolPak's Regression tool are cut off by default because the columns are left at their default width. Please AutoFit the columns as part of the generation of the output. Also, select cell A1 by default so that the output sheet looks cleaner.

    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 →
  15. Behavior of active cell during macro recording and macro execution are different especially when I use End(xlup etc.).

    Active cell wont move when manually select a range using control-shift-xlup or other cursor keys. For example when we select a range from down-right corner to the top-left corner using control-shift-xlup and control-shift-xlleft, active cell is still at the down-right corner. While active cell seems to move to the top-left corner when we execute the same key sequences during a macro.
    Thus it is difficult to reproduce the same behavior by using "Record macro".

    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 →
  16. Suppress Autoopen Macro by holding Shift Key

    Legacy versions of Excel (i.e. those prior to Office 365) enabled you to suppress Autoopen macros from deploying by holding the SHIFT key when opening the corresponding Excel workbooks. This functionality appears to have been lost in Office 365, as holding SHIFT when opening an .xlsm file does not stop the Autoopen macro from running.

    Please can you reinstate this, as its absence feels more like an error or omission than anything else. Thank you ! :)

    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. There is an annoying bug in microsoft excel vba, when using sendkeys, Numlock turns on! Please fix this bug

    There is an annoying bug in microsoft excel vba, when using sendkeys, Numlock turns on! Please fix this bug

    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 →
  18. Porqué no esta disponible en Excel 2016 o mayores la función de month view calendar. ¿Cómo puede sustituir esta función?

    Es necesario que la propiedad de month view calendar se encuentra disponible en versiones de EXCEL mayores al 2013, ya que facilita la selección de fechas validas. Cómo puedo sustituir esta propiedad en una macro de excel?

    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. Reference Comments (NKA Notes) in VBA by name rather than index

    Currently you can only reference comments in vba by their index number, if you know them. There is no known way to determine the comment index number by vba but maybe through a for-next loop searching the text for a known piece. It is possible to name a comment(shape). Since comments do not always get created by the same order or are in the same place, inserting data above or to left e.g., allow the comment to be selected/manipulated by it's shape name.

    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 →
  20. VBA doesn't check the maximum text line length when importing a module

    VBA doesn't check the maximum length of every text line when importing a module (.bas file). This can cause an issue when saving the VBA project inside VBA when the text line of the .bas file is higher then allowed, which can lead at the end to a full crash of Excel. This is a major issue.

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

Feedback and Knowledge Base