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. Getting Data from another excel file copies the cell format and style

    I want to have a separate excel sheet that can get an updated data from another worksheet and also follows the cell format and style.

    I can only get an updated data but it won't follow the cell format and style

    If I do a copy/paste, I can get the data with the format and style but it won't update any data if there are changes from the other workbook

    15 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  2. Add Power BI Dataflows as a data source in "Get & Transform Data"

    Please add Power BI Dataflows as a data source so that I can import data from a Dataflow into the local spreadsheet/data model.

    https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use

    41 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  3. Default the Power Query formula bar as on

    In the Power Query editor window the formula bar is defaulted as off. This is the first thing I tell people to turn on as it’s key to avoiding unintended errors and future proofing your code.

    As Gil Raviv says in his book, “ Enabling the formula bar is fundamental to avoid the pitfalls”

    46 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  4. Let me choose Decimal separator and Date order in PowerQuery instead of guessing

    When importing textfiles using Get and Transform I always struggle with one thing: I do not know upfront what the decimal separator and date order is of my text file. PQ only offers to choose a Locale, but it does not tell me what date order and syntax, nor which decimal separator belongs to this locale.
    I'd love to be able to just choose the relevant separators and date order from a couple of drop-downs. I can almost always see which it is I need from the data, but I hardly ever know which locale belongs to the specific combination…

    28 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  5. Fix this problem: "sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist. "

    Fix this ridiculous problem: "Sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist."

    48 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    7 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  6. Power Query Time Stamp of last updated Data

    Hi All,

    I import data using Power Query from multiple resources and Lots of time I have seen in Power Query that even though we click on Refresh All still not all tables refreshes the data in Power Query Editor.

    So I am looking for feature of option in Power Query that shows last data import date. So that user easily know if all the resources have been updated or not or when it last refreshed ?

    10 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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.

    300 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  8. Implement the Stock Data feature from Excel 365 into Excel 2019 for Desktops

    Basic stock information retrieval is a badly needed feature that should have been added to Excel years ago. A built-in feature would be preferable to hand-crafted solutions created by users or developers with varying skill levels.

    8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  9. Insert data from picture should be implemented on desktop, and it should read PDF's

    Surely you must be aware that this is easily in the top five annoying requests that competent excel users receive from.. other excel users. Why would you not implement this feature to read tables from PDF's in excel proper?!

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  10. Power Query Active Directory Feature

    Hi All,

    I tried to use Active directory feature of Power Query but still not able to find any solution in any forum to speed up the downloading data.

    I have more than ~300,000 records to import (i.e. Distribution list contains each member list) from Active directory but it takes 12-~14 hrs to import using Power Query.

    Can we look into this feature why there is so much time taken by Power Query and How we optimize the same ?

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add Dividend Data to Stock Data Type

    It would be helpful to include the dividend amount per share and ex-dividend date with the stock data type.

    29 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  12. In the Stock lookup list add current annual dividend and dividend period.

    In the Stock lookup list add "current annual dividend" and "dividend period - monthly, quarterly, semi-annual or annual)".

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  13. Bring dividend data for the Stocks data type

    In addition to stock price data, bring dividend data for the stocks

    13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  14. Enable Power Query to Get Data from Excel workbook stored in SharePoint Online document library

    Excel Power Query does not provide an Excel workbook stored in SharePoint Online (SPO) document libraries as a data source. In response to Community discussion, Microsoft suggested a work-around to sync the document library that stores the data source (Excel workbook) with OneDrive for Business, then Get Data from the ODFB copy of the data source. That works, but not for our use case.

    Our use case: We are a very small company with only 1 power user who is proficient with Excel power tools. We want that user to develop the Excel workbooks (that use power tools) that would…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  15. Python Script connector as Power BI

    Using a Python script as data source (like power BI) so then the data analyst can connect directly to a data frame.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  16. Import file TXT with Code M to Power Query

    I often write or receive a few M-language text files to copy and paste in Power Query. When you have only 3 or 4 queries, the process is fast. But when we talk about 10 or more queries, it starts getting tiresome.

    The idea is to be able to create a new query based on a txt file, for example, containing the code in M.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  17. Mysql For Excel: No Connection Showing

    Earlier I used to load the data using Excel MySQL plugin. As of now am not able to see the connections which were added. Look like its a bug from recent ms off update. Please fix the same asap.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  18. Which is the best EDB to PST Converter Software?

    If you are Searching the best EDB to PST Converter Software that can easily Convert your EDB file to PST file then here is a best Software Regain EDB to PST Converter that can easily Convert your EDB file to PST file in just simple and easy process. this Software has simple and easy GUI Interface where you can easily Operate this Software. Both technical and Non technical user easily access this Software.

    You can try this Software free trial version from here: https://www.regainsoftware.com/edb-to-pst-converter.html

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  19. Please update the stock ticker list. Several mutual fund tickers are not included in Excel's Stocks Data Type - including FZROX and FXILX

    Please update the stock and mutual fund ticker list. Several mutual fund tickers are not included in Excel's Stocks Data Type - including FZROX and FXILX

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    48 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

Feedback and Knowledge Base