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. Be able to protect Power Query with password

    Now any user can edit and change Power Query connections, it would be very interesting to be able to protect Power Queries with a password.

    Thanks

    102 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

      9 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    • If pasted text is auto converted to a date: _save_the_original_text_. Then give it back when text is desired. Don't corrupt data!

      When people in computational biology paste a list of gene names sometimes genes like "SPET8" are in the list. The original value is lost, and now the column has corrupt data. (Why did you kill the original value?) Since the column of gene names usually goes off screen and is often in alphabetical order nobody notices this until something breaks in a bizarre way in another person's hands. Scientific papers have had corrupt data for this reason many times, and everyone advises each other to avoid excel for this reason. It might even make a difference for a clinical diagnosis.…

      30 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

        7 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
      • Power Query data from "This Excel Workbook" - Do not break Query if this file name or path changes!

        If you want to have a self-contained file where your data is entered not in table format, but you want to get it INTO a table via PowerQuery, you can currently PowerQuery on the same file via ""From File" and turn it into a table and bring it into that same workbook. But the problem is that now you:
        1) Have to save every time before you refresh the query.
        2) Cannot change the name of the file or where it is saved without breaking the query.
        I believe there's a workaround for #2 involving setting up a parameters table…

        18 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

          7 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
        • Allow PowerQuery to Extract Data from PDF tables

          Allow PowerQuery to import tables of data from PDF files.

          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

            1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
          • Add "Run R Script" option to Excel 2016 and Excel 2013 "Power Query" add-in, as it is for Power BI.

            In July 2016, a "Run R Script" option was added to Power BI Desktop. This option would be a huge benefit to have in Excel 2016 and Excel 2013 Power Query add-in also.

            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

              1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
            • date

              The ISO8601 (https://en.wikipedia.org/wiki/ISO_8601) date format is the de facto standard for formatting dates in internet applications. We use that date format internally and externally for all dates and times, in all datasets and APIs we produce.

              That is until it comes time to creating a CSV file that will be used by Excel. Then these ISO8601 dates simply remain string values and can be very difficult to work with - especially for non-technical stakeholders. Our only solution thus far has been to export three columns in every CSV file: The IS8601 date the rest of our application use…

              14 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 →
              • Harmonize Excel.CurrentWorkbook with Excel.Workbook

                Please adjust the M-function "Excel.CurrentWorkbook" so that it returns the same items (in the same structure) than Excel.Workbook (in connection with File.Contents) does:

                Returning a table view of all elements with helpful columns like "Kind".

                But most importantly also returning content from sheets that isn't in a special format like Table or Defined Name but in a simple range.

                There are multiple reasons for letting the source-data untouched but also performing transactions on them and I've come across this request very often. The workarounds are pretty painful (error-prone and need to save file before being able to access data).

                Thanks…

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

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

                      I received email back from Sam saying he’s expecting this to be the Table Analysis functionality (like key influencers, highlight exceptions), and not the explicit Data Mining features (like clustering). Am going to update the title, and we’ll wait for more votes before considering this item.
                      Thanks, Sam!
                      Ash

                    • Why DDE is not longer supportet

                      Hinweis : In einer früheren Version von Excel haben Sie möglicherweise den dynamischen Datenaustausch (Dynamic Data Exchange, DDE) in Kombination mit dem Seriendruck-Assistent mit Schritt-für-Schritt-Anweisungen in Word verwendet. DDE wird von Excel nicht mehr unterstützt. Wenn Sie möchten, dass dieses Feature bei der nächsten Version von Excel berücksichtigt wird, übermitteln Sie uns einen entsprechenden Kommentar in der Excel Suggestion Box.

                      7 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 →
                      • Amazon Redshift Connector

                        Creation of an Amazon Redshift Connector for Power Query that is similar to Power BI.

                        https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-redshift/

                        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 →
                        • Get and Transforms needs to support AAD Authentication

                          Please provide support for AAD authentication to SQL Database sources. The fact that this can be done at the cloud level (article reference below) but doesn't work with key client tools such as Excel is a disappointing limitation.

                          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

                            1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                          • Default CSV Fields as TEXT PLEASE!!!!!

                            Excel is horrible for data files, yet it doesn't have to be! When opening a CSV data file it converts numeric strings to Scientific notation which is actually useless because it loses precision and cannot even be converted back and truncates leading zeros on fields like zip codes! For the love of GOD why do you need to do this? how many people in America actually use Scientific Notation? Seriously. Why can't I open a CSV file without you converting my fields. I work in the mailing industry and have been fighting this nonsense for ten years and I have…

                            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

                              1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                            • 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

                                2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                              • Generic OpenID Connect Support for Web and OData sources

                                For Web and OData service data sources - provide a custom authentication dialogue option in PowerQuery. I really just need to be able to invoke a browser client, the user login can then login, negotiate auth (OIDC, OAuth, SAML, WS-Fed, etc...) and then I would parse the response for a relevant token to pass to the API endpoint.

                                The OData feeds are incredibly limited in terms of security today. Generally, as an implementation of REST, there are going to be few OData services with meaningful information behind Basic Auth or allow Anonymous access. API keys (shared secrets) are impossible to…

                                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

                                  1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                • Allow me to merge several cells of text

                                  I import lots of data into excel but I spend even more time formatting it once I get pulled into Excel. Can you add a merge feature to merge numerous cells? I know I can merge cells next to each other but cells above and below I can't.

                                  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

                                    3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Add support for SQLite databases as a data source in Excel

                                    SQLite, an open-source relational database and one of the most widely deployed and used database engines.(https://www.sqlite.org/mostdeployed.html).

                                    It would be really useful to be able to query sqlite databases directly in excel. Either to just view data or for further analysis using powerpivot.

                                    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 →
                                    • Color cell to sum number cell

                                      Post a number in a in a cell based on the color of the cell nest to it. IE sum cells c2-c5 if color of cell d2-d50 is red/green.

                                      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

                                        1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Allow Data Validation (List) in locked cells

                                        To prevent a user overwriting data validation with copy and paste. if I use locked cells and Protect the sheet, the Data Validation drop down doesn't work. All a function within "Protect Sheet" options, for "Allow Data Validation" please.

                                        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 →
                                        • creating Layout of directory in excelsheet directly from your local hard drive

                                          if it was possible that just with one click, we can create a Tree Grid Map of directory, which will give option of inducing sub folders & files with option of inserting hyperlink.

                                          So that i don't have to open 7-8 sub folders before opening my files.

                                          (nothing against VBA, its a great tool) if i create a directory using VBA it is not very beautiful..... i wish i could see small folders with little Expansion buttons it would be very great.

                                          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

                                            0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4
                                          • Don't see your idea?

                                          Feedback and Knowledge Base