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…

    73 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

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

        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

          1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
        • Language-Integrated Query (LINQ) for VBA

          Language-Integrated Query (LINQ) for VBA!

          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 →
          • Can't add ActiveX into Excel 2016

            Unable to add new/existing ActiveX controls into Excel 2016 whether it is a brand new worksheet or an existing worksheet. Getting an "Cannot Insert Object" error. Have researched previous issues on this and there are only fixes up until Office 2013. Requiring assistance in finding a fix to this issue ASAP.

            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 →
            • 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…

              7 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 →
              • 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
                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 →
                • 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

                  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 →
                  • freeze panes via VBA without needing to activate the sheet

                    in VBA there is no way to split & freeze a sheet without Activating the sheet first.

                    Most tasks can be programmed to change a sheet without the sheet being Activated.

                    So, please provide a means to add/delete/control split & freeze panes programmatically in VBA without the need to activate the sheet first.

                    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 →
                    • 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 →
                      • 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 - Insert_Column
                        ** 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 …

                        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 →
                        • 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 →
                          • Give option to make PERSONAL macro file AutoRecovery file automatically load instead of the original file

                            When excel crashes the 'PERSONAL' macro autorecovered file is listed but the original file is automatically opened too which makes saving the autosaved one a pain in the **** as it is now called PERSONAL (autorecovered) and as the original is open you can't just rename it and save. It should just auto open the autorecovered one and then just ask if you want to save as normal when you close excel. I would actually prefer this for all autorecovered files.

                            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 →
                            • translate

                              please remove translator in menu key in excel, it doesn't help but rather slows the excel user is pasting and copying. please please, no disregard to its creator, but i hope this feedback will notify you. please use any other letter not S

                              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 →
                              • when changing an addin ask to save when closing Excel

                                Now when I have changed an addin and close Excel the addin is not saved unless I push the button. Just like other files I want that Excel ask me if I want to save or not

                                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 →
                                • 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.

                                  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 →
                                  • Disabling Page Layout View From VBA

                                    Disabling Page Layout View From VBA

                                    Allowing the user to change this breaks frozen panes.

                                    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 →
                                    • 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 →
                                        • 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!

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

                                          Feedback and Knowledge Base