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.

Take a look at the feedback that we are currently working on and what feedback we have already completed.

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. 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…

    15 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    • "Power BI Service" as a data source in "Get & Transform"

      It would be awesome if "Power BI Service" is added as a data source under "Get Data" in "Get & Transform Data" in Excel. Though the source availability is already there with "Power BI Publisher Add-in" but it is buggy and hard to deploy on large number of laptops/desktops. Also, it is practically very difficult to educate down the line users about re-enabling this add-in via COM Add-ins in case it disappears from the ribbon which is very frequent in case of this add-in. We have been struggling with this for a long period of time now.

      Considering "Power BI…

      22 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
      • Have an option to turn OFF scientific notation. It is causing errors in our Real Estate parcel number data

        I work with Real estate Tax Assessor data, and I would love to see a feature where you have an option to turn OFF scientific notation in cells. This really screws up the integrity of the data, and it is not necessary! Judging by the similar posts on here, there should be a switch somewhere to turn this automatic feature OFF. Thank you for your consideration. EP - Zillow Group

        2 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
        • Re-enable authentication capability for the PowerQuery Web.Page() call

          The new style "From Web" wizard presents a very nice, clean and simple "Enter the URL" dialogue.
          For an authenticated service it then asks for authentication details.
          Web.Page(), however, does not support authentication and so this cannot work.
          Using PowerQuery options to retrieve as text and then massage the response is inordinately more complicated and thus subject to additional user error, more sensitive to changes in the data supplied and produces a .xlsx file that is unnecessarily bloated.
          We had put together a process to update the URL in the .xlsx file so that we could supply our customers with…

          5 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
          • Power Query - Sizeable box or editor in the database conection dialouge

            I have often to put large (existing) sql statements into the database conection dialouge. It is verry difficult to ajust or edit these statements in the small box. A sizeable window or an editor would be verry helpfull.

            2 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
            • Change default settings for data preview in background

              I really hope that this is something the team is already working on, but just to make sure:

              Please change the default-setting in Power Query for Data Load: Background data -> "Allow data preview to download in the background".

              This should be DISABLED by default.

              So many people are not even aware of how much unnecessary waiting time this default-settings can cause. At least this "performance"-stopper is avoidable in Power Query!

              17 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
              • Pin folders

                Hello! I - and a lot of my colleagues want this feature so you can pin folders . Now in Excel 2016 you can only pin files. In elder versions of excel you could pin both files and folders.

                4 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                • 2 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                  • Control default date-time format from system locale (like date and time)

                    You can set the default time format in system locale settings and Excel will follow it.

                    You can set the default date format in system locale settings and Excel will follow it.

                    However when Excel import a field which is a date-time such as "DD-MMM-YYYY HH:mm:ss", it doesn't follow either of these system locales and instead imports it as "DD-MMM-YYYY HH:mm". There is no way to change this default setting for importing a csv with a date-time field featuring seconds when double-clicking on it.

                    Worse if you then re-save that csv as a csv before correcting the format it cuts…

                    6 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                    • To be able to copy the directory list from a USB drive's and paste into Excel sheet.

                      To be able to copy the directory list from USB drive's and paste into Excel sheet. As a record of what is on each of the USB drives, without having to keep opening them time after time.

                      1 vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                      • Allow interaction with Excel while in Power Query

                        Please make the Power Query editor window (Get Data) non-model. When building complex queries, we often need to go back to Excel to change a worksheet and look at data. Right now, the Power Query editor window takes control over the application, preventing interaction with Excel.

                        The current behaviour makes it very difficult to do things like the following:
                        -Mid query, go back and check a worksheet to see exactly what a cell value may be that you want to refer to
                        -When we have a static table in Excel and are trying to build a query that lands an…

                        127 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          11 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                        • Return to 2013

                          I used to be able to link the values of cells in one workbook with the cell in another workbook simply by typing = in the cell of the receiving workbook sheet and double click on the sorce cellk in the source workbook. Now it no longer works why

                          2 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                          • Dynamic Data Exchange (DDE) was very useful, please restore it

                            Dynamic Data Exchange (DDE) was very useful, please restore it

                            6 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                            • 1 vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                              • Ability to import stock price w/ auto-update feature

                                As of 11/2017 Yahoo.Finance no longer provides free stock prices. This was used by many users in multitudes of files/worksheets/folders/applications. We need a simple option to pull daily/current stock quotes w/ an auto-update feature. There are people that would obviously like more than the stock price, but this would be a bare minimum start.

                                1 vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                • Excel 2016

                                  When a copy of an Excel 2013 document is copied into the Excel 2016 version , the column & row sizes are changed causing an OMR document to be invalid,
                                  ( Example the column width of 1,44 changes to 1,57.)
                                  Is there a fix for this ?

                                  Lester BLACK
                                  www.golfrapidresults,com

                                  1 vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Salesforce permissions in power query for multiple organizations/environments

                                    When using Power Query to access objects in Salesforce, the only login choices that are saved are for Production or Sandbox.
                                    Salesforce uses the user ID to determine which Production Organization or Sandbox we're accessing. Because we do work for multiple organizations, it would be useful to have the connection information stored with the workbook instead of centrally with Excel. Having to clear the permissions every time I switch a spreadsheet I'm working with is frustrating.
                                    Thanks! (Couldn't live without Power Query!)

                                    1 vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Split query results

                                      Mechanism for splitting the result of a query into sheets or workbooks with names from a specified column in query. To create workbooks, make possible to select a folder.
                                      This will save a lot of time for everyone who need split tables for different users on some basis.

                                      3 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                      • OneDrive Data Source

                                        I've got an Excel workbook that provides data for a Publisher file. They're in the same OneDrive folder. When I open the Publisher file on my main computer, it pulls the data from the Excel file. But if I open it on another computer, it fails, because the file path is different on a different device. Couldn't it be set up so that it navigates to the right file, since it's all stored in the cloud anyway?

                                        1 vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Power Query - Connect to One Drive personal

                                          Allow Power Query to connect to a CSV/txt/Excel/Access File stored on one Drive personal

                                          Currently the only way to do this is via a URL hack - Please support this formally

                                          1 vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            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 6 7 8
                                          • Don't see your idea?

                                          Feedback and Knowledge Base