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

    13 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!

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

        111 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

          10 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 →
          • Provide more diagnostics for the data / from web process to help developers of the web service resolve the problem with http basic auth.

            At the moment, Excel is failing to recognise that the http basic authentication was successful and refuses to ingest the data into the spreadsheet.
            The web server is returning an http-200 and the data requested, but Excel is saying that the supplied credentials did not work.

            With no insight into why Excel thinks it didn't work, how can I fix my web service*?
            Why is Excel not recognising this when IE11, FireFox, Chrome, Opera and Vivaldi all say it works fine?

            Prior to the re-working of the Data ingest process in Office 2016 earlier this year, this all worked fine.…

            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

              8 comments  ·  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…

              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 →
              • Option to get old text data import wizard

                The new data import editor has some major flaws:

                First, it takes 100 times longer to import some simple 500 rows of data
                Second, the date format selection for columns (e.g. I want to convert MM/DD/YYYY format to DD.MM.YYYY)

                I understand that the new import editor has some advantages but I do not need any of the new functions it has. The old text data import wizard could do everything I needed it do do.

                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

                  12 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

                  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 →
                  • Allow equal key column names in Table.Join (Power Query)

                    In Table.Join function we can use same key column names for JoinKind.Inner option, but need to use different column names for other join types, like Left Outer, Right Outer etc. This limitation demand to add excessive steps for renaming duplicate columns before join and removing them after join.
                    As Table.Join is much faster and effective than Table.NestedJoin in complex preparation, this seems to be unnecessary and dilatory limitation and should be removed.

                    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 →
                    • I want my Old Style Feature of "GET DATA FROM WEB", I hate the new style "GET DATA FROM WEB" on Office 365.

                      I want my Old Style Feature of "GET DATA FROM WEB", I hate the new style "GET DATA FROM WEB" on Office 365. I can not Login on website using "GET DATA FROM WEB" on Office 365. I wishthere is button for using old style of "GET DATA FROM WEB"

                      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 →
                      • Importing External Data from relative links

                        Importing External Data is for ages done with absolute file link. Can it be implemented a way to have a coice to import data using relative

                        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 printing of Query Dependencies in Power Query

                          Allow the printing of the Query Dependencies view, both the graphical view and also provide a text view/listing of dependencies. Would allow for easier documentation of larger and more complex models.

                          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 →
                          • Manage Excel Table Totals Row import in Power Query

                            is there a possibility to NOT load totals rows from Excel table?

                            I'm ususally do not use totals in tables so wasn't aware, but now met an unpleasant situation when unfiltered totals row causes problems.

                            I understand that we can filter it out after loading (but sometimes its existence could be recognised only with eyes, not automatically by values), but from my VBA experience these are different properties of ListObject: ListObject.DataBodyRange and ListObject.TotalsRowRange.

                            It could be great if we'll have a possibility to manage somehow, whether we want to import totals row from a table.

                            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

                              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…

                              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 →
                              • Restore the pasting of tab separated text into columns from an HTML <pre> block and web data feed that has been removed from v16.0.7927.1020

                                When using data/from web or pasting a table from word or pasting an HTML <pre> block from a web page the tab separated data used to get automatically placed into columns. With v16.0.7927.1020 this has stopped - all the data goes into one column. There remains the option (checked by default) to do this when ingesting data from the web, but it no longer happens. When ingesting data from a web feed, you can't use the "paste as text" option to achieve this effect, so this change in behaviour has effectively broken our application's reporting facility. It still works in…

                                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

                                  10 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                • Integrate Excel with other powerful statistical tools/apps

                                  Improve the capability of Excel to share data & graphs directly (without the need to save the data as a separate CSV/tab-delimited file for import/export into and out of Excel) with other powerful statistical tools/packages (such as R).

                                  Also, integrate support in Excel for other popular programming languages besides VBA which are widely used in data mining and feature analysis (such as Python), so that Python-based machine learning packages (such as scikit learn) may be directly utilised in Excel (potentially as user-defined / custom-built macros).

                                  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 →
                                  • pulling external stock quotes from the web

                                    was just advised by microsoft tech support that 2016 version does pull live stock quotes from the web like previousversions..

                                    are you kidding?

                                    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 →
                                    • With autosave inplace, how can we continue to retrieve files if we lose the internet again? Hurricane Irma in point.

                                      We lost our electricity (backup generator) and access to the internet during hurricane Irma (Florida). How can we insure we can continue to retrieve needed files with autosave turned on?

                                      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 →
                                      • Simplify Command Keys in Using Data,Get Data,Launch Query Editor

                                        In Excel 2016, Data, Get Data, Launch Query Editor, the commands are given in the normal way such as Alt+A,R for Refresh All, but are all numbered as Y01,Y02,Y03,Y04 for the top level and then Y01,Y02,Y03 up to Y31. This makes it very cumbersome to work with.

                                        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 →
                                        • Business data (e.g. reference rates, fixing prices, etc.) are often provided as .csv files

                                          Business data (e.g. reference rates, fixing prices, etc.) is often provided as .csv files. If you really want to enable people working professionally with their Android devises a converter into excel on Android is highly and urgently necessary!

                                          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

                                            1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 6 7
                                          • Don't see your idea?

                                          Feedback and Knowledge Base