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.

How can we improve Excel for Windows (Desktop Application)?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Create a command line tool for signing Office files with a digital certificate

    Besides Office, Excel files can be created using numerous software tools. More often than not, batches of macro-enabled Excel files are processed with scripts for productivity purposes. However, VBA code signing cannot be part of an automated process, as it is a manual task that requires opening & saving the file in Excel.

    This request is about creating a command line tool for signing Office files with a digital certificate, similar to MS SignTool.

    In addition, the existing macro signing process in Office is not 100% compatible with Open XML specifications. I can clarify this statement in a private discussion…

    63 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      18 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    • Option to save VBA changes but not worksheet changes

      Use case: in my world, we have templates that are frequently updated. As a result, the VBA has to be updated and tested as well. I'm not an expert programmer, so there are often many iterations of code tweaks, test, repeat.

      The problem is that the template is affected by the code- rows and columns are added/deleted based on the sample data, etc.

      So I either have to close without saving, and keep a handwritten log of the next few lines of code I've identified as requiring edits, or, I save the file but then have to go copy/paste the…

      3 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        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 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
        • Ensure that updates do not corrupt VBA macros

          After moving from Office 2010 to 2016 (on-prem), our users began to experience severe problems with macro-enabled workbooks (XLSM). These workbooks would not open, or open with errors, or the macros would crash Excel when run, or opening the workbook would crash Excel, or the Visual Basic Editor in Excel would exhibit weird behavior.

          In all cases, the problem could be solved by opening the XLSM without active content enabled, and recompiling the VBA project. But in all cases, these were VBA projects that had worked normally before, and had been succesfully compiled before.

          Recently, we rolled out an update…

          4 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

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

            3 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
            • 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.

              2 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
              • Allow Excel to connect to"Mail"for the "SendMail" macro command

                Enable Excel to connect to "Mail" for the "SendMail" macro command.

                1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

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

                  1 vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

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

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

                    3 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

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

                      6 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                      • 1 vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                        • Export to powerpoint

                          When working with data, presentation is am important part. Currently Excel does not have a function or add-in to export a file to powerpoint which is a big gap in Excel offering. Other competitors have taken advantage of this and have managed to get slice of Excel business out from some of big businesses. Please create an add-in to Export excel files to Powerpoint.

                          1 vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            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 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

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

                              1 vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                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 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                • 1 vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

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

                                    3 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 1 vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Provide a way to convert old Excel 97-2003 macros to be compatible with the newer versions.

                                        Provide a way to convert old Excel 97-2003 macros to be compatible with the newer versions.

                                        2 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                        • 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
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 10 11
                                          • Don't see your idea?

                                          Feedback and Knowledge Base