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. Show Tables in Power Query when opening an xlsb file

    When using Power Query / Get Data to open .xlsx files and .xlsm files, the Tables present in those files are shown in a list.
    When opening a .xlsb file only Sheets are shown and not any of the Tables present within the file.

    If there is only one table on a sheet, AND it starts in cell A1, then it is relatively easy to still load the data, but where there are multiple tables per sheet, OR the tables don't start in A1, then there is a lot of unnecessary work deleting Rows and or Columns to obtain your…

    35 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

      10 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    • Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems

      It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often results in Formula.Firewall warnings or other issues.

      This leads to having to switch Privacy Levels to "Ignore" or having to write a query within a query rather than nice and clean "parameter" queries.

      It would really simplify things if we could quickly create parameter queries (including a drop down to select parameter type) and that these queries would be immune from the Privacy warnings.

      155 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

        3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
      • Add support for custom data connectors (Power Query M extensions)

        Custom Data Connectors mechanism is being developed by Power BI Desktop team:

        * https://github.com/Microsoft/DataConnectors
        * https://github.com/Microsoft/DataConnectors/blob/master/docs/m-extensions.md

        Excel's Get & Transform engine (Power Query) should have support for *.mez/*.pqx extensions too.

        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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
        • Improve Queries and Connections Task Pane

          Having used the newfangled Queries and Connections pane for some time now I find it is time to add some suggestions

          My issues:

          1. The pane does not remember its size
          It opens really narrow on my system, displaying only a (very) small part of the connection and query names so my first action every friggin time is to drag it wider.

          2. No multi select
          in the old connections window you can control or shift-click multiple connections to delete them. For maintenance this is a very useful feature I miss regularly.

          3. It isn't application-centric
          If I open a…

          18 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

            2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
          • Power Query - Add option to retain all cells (nulls and errors) when using Unpivot Other Columns

            Using Power Query to Unpivot other columns is an amazing feature but it automatically removes nulls and errors.

            Add a drop down down (maybe an advanced option) to Unpivot Other to allow the keeping of all items

            17 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

              3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
            • full anti join (Power Query)

              Do a Right and Left Anti Join in one sweep. So figure out the outliers in both tables in one go.

              9 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

                2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
              • turn off automatic date conversion

                Opening scientific data in excel for review or analysis purposes is a nightmare in Excel. Some values, gene names and other text automatically transforms into dates and then the data is corrupted. Changing cell format in this case corrupts the data even further and there's no way to return to the original value/text, since the data corrupts when opening the file. This is the worst functionality in Excel and I don't know anyone who benefits from the automatic transformation of dates. Please the date transformation optional setting for those who might need it!

                19 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

                  4 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                • Power Query Editor - Allow us to make the final right hand column wider

                  Currently we are able to make every Power Query Editor column wider, except for the last one! Which when using the Add Column functionality is the one you really need to be able to expand.

                  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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                  • Excel 365 Data from Web is super slow and ******

                    The new interface is ****, takes 5 minutes to even load up the data connection, opposed to the old interface that took a few seconds.

                    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                    • Power Query Remove duplicates in sequence

                      I was flabbergasted to find out that with out warning. Remove Duplicate does not honor the previous steps sort order.

                      This is fundamental, and no, repeat no warning to the user of PQ until looking in detail at the results. This has been in place on data inside the worksheets for a very long time.

                      After searching you can use Table.Buffer to hold the sorted step then remove duplicates, but this has an impact on performance.

                      two points

                      1) - If remove duplicate cannot use previous steps sort order to remove duplicates in sequence, moving forward due to a technicall…

                      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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                      • Bug: No files shown in the "Add Tables" dialog of MS Query when using the MS Access Text driver

                        Bug: No files shown in the "Add Tables" dialog of MS Query when using the MS Access Text driver

                        When using Excel 365 / 2016 and MS Query with the MS Access Text ODBC driver no tables (Files) are shown in the "Add Tables" dialog

                        Please see attached document for configuration and steps to reproduce

                        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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                        • that you can give a listing of all the different simple formulas so that its easier to do

                          that you can give a listing of all the different simple formulas so that its easier to do

                          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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                          • Recover exchange edb file

                            Recover exchange edb file by the help of sifo systems edb file recovery tool .This exchange edb recovery tool easily recover edb file and convert edb data to pst format .
                            This software has good support with all version of exchange server edb file that are edb 2016,edb 2013,edb 2010,edb 2007,edb 2003,etc .

                            Go for free download of software ,click here :- https://www.crunchbase.com/organization/recover-edb-mailbox-via-edb-to-pst-recovery-software

                            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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                            • Sifo systems edb to pst converter software

                              Sifo systems edb to pst converter software is swiftest application for removal of virus & errors from edb file .
                              I mean to say that sifo edb to pst software is good for exchange server recovery .By using this sifo edb recovery tool you can recover ,convert complete of edb file to pst file with all data like as inbox,calendar ,notes,contacts,task,etc .

                              Software support all version of exchange edb file that are edb 2016,edb 2013,edb 2010,edb 2007,etc .

                              Go for free download of software ,click here :- https://www.crunchbase.com/organization/sifo-systems-exchange-server-recovery-software

                              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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                              • Allow to use a power query column as a source for a data validation list

                                When selecting a source for data validation --> list, it would be useful to allow selecting a query from "power query" that hasn't been loaded to an spreadsheet.

                                With this, the workbook could be maintained tidy

                                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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                • data validation needs to miss out blanks and show only those in the list.

                                  data validation needs to miss out blanks and show only those in the list. Google sheets has this function and is super handy

                                  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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                  • update links to other files as first choice when opening a spreadsheet

                                    I have many files that have links to at least 20 other files. When opening one of these files, I have to go through two warning boxes for each and every linked files because since we migrated to Office 365, Share point and one drive, excel can not locate the files. After going through at least 40 warning boxes, I finally have the option to not update links. This option should be the first choice to avoid having excel tell me what I already know - that the file links cannot be found through sharepoint. This would be a Huuuuuge…

                                    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Data link for Current Stock Prices and Historical Data Into Excel from Morningstar, Fidelity, T. Rowe Price or other brokers.

                                      Excel Import Data link for:
                                      01. Current Stock Prices and Historical Data from Morningstar, Fidelity, T. Rowe Price or other brokers.
                                      02. Current Weather information or statistics from common Weather sites or Bing.com/weather
                                      03. Data mining of online information as part of the Data Analysis Ribbon,
                                      To calculate descriptive statistics for the data set, follow these steps:
                                      Click the Data tab’s Data Analysis command button to tell Excel that you want to calculate descriptive statistics.
                                      In Data Analysis dialog box, highlight the Descriptive Statistics entry in the Analysis Tools list and then click OK.
                                      04. Options for predefined and custom…

                                      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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Dropdownlist from a dropdown list

                                        Make a dropdown list from a dropdown list as for example first dropdown is a brand and the second dropdown is a type

                                        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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Power Query search box or an "In Focus" tab

                                          If you have many queries of different types (functions, parameters, load queries…), I know you can "put" them in different groups, but that still doesn't give you a good overview of them and turns out to not be so practical when you hit about 20 queries. Would love to have a Search Box to find them quicker or a sort of an "In focus" ability of Outlook mobile app with two tabs of queries that would reference a query property that one could set and get far better overview of Queries where the desired result would be to find what…

                                          17 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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 10 11
                                          • Don't see your idea?

                                          Feedback and Knowledge Base