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. Can't move text cursor to the end of a line that ends in a whitespace character in Power Query's Advanced Editor with IntelliSense turned on

    The title of this suggestion is a mouthful, but it is a common scenario and an annoying issue.

    Suppose that you are typing in Power Query's Advanced Editor and IntelliSense is turned on. You type a line that ends in a whitespace character (tab or space), but before finishing it, you move your text cursor elsewhere, perhaps to copy the name of a variable to later paste in your unfinished line. If you move your mouse cursor past the end of the unfinished line and click, the text cursor disappears rather than appearing at the end of the line. This…

    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 →
  2. Add Undo and Redo buttons to Power Query's Advanced Editor

    The Advanced Editor supports the shortcuts for Undo and Redo (Ctrl + Z and Ctrl + Y, respectively), but it does not have buttons for them. Not every user will know these shortcuts or assume that they will work. The buttons will allow the user to undo and redo stuff without requiring them to learn something ahead of time. Please add the Undo and Redo buttons to the Advanced Editor.

    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 →
  3. In Power Query, overload Date.StartOfYear to accept a year as its argument

    Currently, Date.StartOfYear accepts a date/datetime/datetimezone as an argument and returns a date/datetime/datetimezone that represents the start of that argument's year. Please also give us the option to provide a year as this argument. For example, Date.StartOfYear(2019) should return the same result as #date(2019, 1, 1). The beauty of using Date.StartOfYear instead of #date(, 1, 1) is that the intention is clearer and it avoids the hard-coded the 1s.

    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 →
  4. In Power Query, Table.ReplaceValue should not ignore errors returned by the function used for newValue

    In Power Query, the function Table.ReplaceValue allows either a value or a function to be used as its newValue argument. If newValue is a function, and if that function returns an error, then that error is not used as the replacement in the output. Other functions, such as Table.AddColumn, that also populate a column based on a given function, show the error in the values of the column. Table.ReplaceValue should behave this way as well. Its current behaviour hides errors and makes debugging more difficult.

    The Power Query code below demonstrates the different behaviour of Table.ReplaceValue and Table.AddColumn.

    let

    #"Table"
    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 →
  5. 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…

    3 votes
    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 →
  6. 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)".

    3 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. Stop IntelliSense suggestions when "then" or "else" is typed in Power Query's Advanced Editor

    I'm sure that I'm not the only one that likes to split my "if" statements into multiple lines for readability, usually like this:

    if <condition> then
    <expression if true>
    else
    <expression if false>

    The problem is that after I type "then" or "else", IntelliSense still tries to predict what I'm going to type, and when I hit Enter to move to the next line, it instead accepts IntelliSense's suggestion.
    "then" becomes "SapHanaRangeOperator.GreaterThanOrEquals".
    "else" becomes "ExtraValues.Error".

    I need to remember to hit Esc before hitting Enter or hit Enter and then press Ctrl + Z to undo accepting the suggestion. This…

    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 →
  8. Lost keystrokes in the Power Query Advanced Editor when IntelliSense is turned on

    When IntelliSense is turned on, Power Query's Advanced Editor slows down. That is, when I'm typing, there is often but not always a delay of 0.5 to 1 seconds before the character that I typed appears. This is obviously not ideal, but I would be able to live with it better if all of the keys that I pressed eventually showed up, but this is not the case and it is a huge pain.

    For example, if I typed #"Remove Duplicates", I might see something like #"ReoveDupliates", and then I need to go back and fill in the missing letters.…

    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 →
  9. Change the data type icon from "1.2" to "123" for columns of type Int8.Type and Int16.Type in Power Query

    Int8.Type and Int16.Type share the same data type icon as "type number" despite being integer data types like Int32.Type and Int64.Type. Please change the data type icon for Int8.Type and Int16.Type to be the "123" that Int32.Type and Int64.Type use instead of the current "1.2" that "type number" uses.

    To see what I mean, run the code below and you should get something that looks like the attached screenshot.
    Table.TransformColumnTypes(

    Table.FromRecords({[#&quot;type number&quot; = 0, Int8.Type = 0, Int16.Type = 0, Int32.Type = 0, Int64.Type = 0]}),
    
    {
    {&quot;type number&quot;, type number},
    {&quot;Int8.Type&quot;, Int8.Type},
    {&quot;Int16.Type&quot;, Int16.Type},
    {&quot;Int32.Type&quot;, Int32.Type},
    {&quot;Int64.Type&quot;, Int64.Type}
    }
    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 →
  10. Bring dividend data for the Stocks data type

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

    18 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 →
  11. 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 →
  12. 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.

    3 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. Export all mailboxes to PST Exchange 2010

    Exchange EDB to PST Converter that has the power to extract EDB databases like emails, contacts, chats, tasks, notes, journals, and appointments to a new PST file. With this EDB to PST software, the user can easily retrieve all the database from any corrupt EDB file without using any difficult technical skill. It supports all version of Exchange Server and MS Outlook (including 2016, 2013, 2010, 2007, 2003, 2000, and below version) to easily make the conversion of EDB file to PST.

    Get more info:- https://www.esofttools.com/exchange-server-database-recovery.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 →
  14. Under the "Stocks" data type - add FORWARD P/E ratio

    The "Stocks" data type includes the current price-to-earnings ratio (P/E). However, in terms of present stock valuation it is much more common to value a business (or the market more broadly) based on the level of it's FORWARD P/E ratio.

    I'm excited that it's been added to Excel, but until this is available the new data type is of limited use.

    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 →
  15. 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 →
  16. How to open password protected 7zip file - eSoftTools

    eSoftTools developed a smart tool to unlock the 7z file without password named as 7z unlocker tool. It removes all password combinations without any failure in a few minutes. it has tree recovery process- mask attack, brute force attack and dictionary attack and works with all windows or 7z platforms. This tool offered a free Demo version which gives you permission to get back first three character of 7z file password.

    Read More - https://www.7zunlocker.com/

    ANd also complete details - https://www.7zpasswordrecovery.com/

    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 →
  17. network shared file

    When opening a file over a network drive, get the validation message asking if it is safe. Wondering if there is a way to ask to put the network file in a white list or the directory? Completely understand why the validation message pops up. If the file or directory is allowed to be whitelisted and is no longer an annoying message to edit the file, it give validity to the prompting and make excel/office a little more user friendly. Thank you.

    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. Allow formula to be used for Stock Data reference

    It would be useful if the new Stock Data function was be able to reference a cell that contained a formula.

    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 →
  19. Allow aggregation of text when doing Group By in PowerQuery

    When doing Group By it is possible to choose an aggregation but it is not possible to do Text Aggregation (using concatenation) using the UI.

    It is possible to aggregate strings using "Text.Combine" in the advanced editor but it is a common enough operation that I think it should be added to the user interface.

    See https://excelgorilla.com/power-bi/power-query/aggregate-text-values-using-group-by/ for an example of doing it in the advanced editor.

    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 →
  20. 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.

    54 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 →
  • Don't see your idea?

Feedback and Knowledge Base