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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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…

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

    We’ll send you updates on this idea

    43 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

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

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

    We’ll send you updates on this idea

    25 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for taking your time to suggest and vote for being able to protect Power Query with a password. This is a good idea, but we don’t think we’ll be able to support this in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

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

    339 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 →

    Hi all,

    Thank you for taking your time to suggest and vote for adding Get Parameter button to Power Query. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Thanks,
    Guy Hunkin
    Excel Program Manager

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

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

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

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

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

    We’ll send you updates on this idea

    8 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  9. WE NEED! Dynamic Data Exchange (DDE) in combination with the Step-by-Step Mail Merge Wizard in Word

    WE NEED! Dynamic Data Exchange (DDE) in combination with the Step-by-Step Mail Merge Wizard in Word. Formatting columns as text to make this work correctly (ie, Zip + 4) is ridiculous!

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    8 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  11. Add a setting/option where all CSV/delimited files are opened as "Text"

    Add a setting called
    "Open text-delimited files (CSV, etc) as text only, with no type inference."

    When this setting is active, then every column's format will be "Text" when a CSV or other such file is opened, so that the initial view is exactly the text represented in the CSV.

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

    We’ll send you updates on this idea

    31 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    info needed  ·  Yigal Edery responded

    Thanks for the feedback!

    Can you comment on whether you expect this to basically import all the lines as text to column A, or if you have some other expectation?

    Also, I’m assuming people refer here to the file/open path, and not to the Data/From-Text or New-Query/From-Text path.

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

    65 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 →
  13. 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”

    64 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 →
  14. Add UnDo to PowerQuery

    PowerQuery is one of the best improvements added to current EXCEL! When importing data from almost all relevant sources, I can undo each single step of data-Import or transformation, even in non-temporal order.
    BUT: if i drop a hole query, delete a table or something that is not in the steps list, or if i delete a step: this cannot be undone.
    Please allow UNDO for
    deleting queries
    deleting steps
    changing steps
    (not adding wrong steps, this can be undone with deleting the step)

    This would be a very great improvement! Today i deleted a query with many, many steps…

    49 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 →
  15. 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.

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

    We’ll send you updates on this idea

    20 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  16. Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

    The Query Editor allows you to easily create Year, Month, Month Name etc, but many people need Fiscal Month Number and Fiscal year

    45 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 →
  17. Make Insert Data From Picture Option Available for Excel Desktop

    Insert Data From Picture has been rolled out for Excel Mobile.

    https://support.office.com/en-us/article/insert-data-from-picture-3c1bb58d-2c59-4bc0-b04a-a671a6868fd7

    Please make this available for Excel Desktop. (Or is already available? If so how to access it?)

    44 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 →
  18. Incremental data load in PowerPivot through Power Query

    Please,

    We work with very large databases. Every time we update the information, it reloads all the data in the Power Pivot through Power Query, which takes a long time.

    Undoubtedly we can make separate queries with the history and have the results added by DAX, but this forces us to duplicate all the metrics in DAX and parameterize everything.

    Our request is whether there could be any way to update the data incrementally???? it would be fantastic.

    Thank you.

    PD.- Now we are using and we recommend our clients to use PowerUpdate that allows to program the update of…

    43 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 →
  19. 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…

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

    We’ll send you updates on this idea

    11 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  20. Add short month name and short day name in Power Query

    In Power Query, you can convert a date in year, month, day, first day of the month, day of the week, .... You can also convert a date in month name or in day name.

    But there is no option to convert a date with the short name (Jan, Feb, Mar, ...) and the same for the day (Mon, Tue, Wed, ...)

    Is it possible to add these options on the ribbon?

    40 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 →
← Previous 1 3 4 5 21 22
  • Don't see your idea?

Feedback and Knowledge Base