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. select date for open/close stock

    You should be able to pick dates when selecting stock info.

    E.g set the date as 06/11/2019 to get XNAS:MSFT open price on that day.

    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. Give the option to show metadata above tables that are loaded from queries.

    It would be nice to be able to show meta-data above tables that are loaded from queries. An example of this would be displaying the notes that are in the properties of the query two rows above the loaded table. Here are a few more examples: source data name or file location; last refresh time; errors; code-based message, hyperlink to the query, etc.

    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. Stocks data - UK OEIF Funds

    J P Morgan Natural Resources Inclusive Class A Accumulation Fund (This is a UK fund) cannot be found under the Stocks Data listing. Please include. have tried looking for various different spellings etc.

    JPM Natural Resources Fund A - Net Accumulation (0P00000RC8.L)
    LSE in GBp

    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. 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. Error in Table.AggregateTableColumn of Power Query M

    Table.AggregateTableColumn of Power Query M doesn't allow usage of type as 4-th parameter of an aggregation for last aggregation. I.e if you do this:
    Table.AggregateTableColumn(aTable, {"F1", List.Max, "NF1", type number}, {"F2", List.Max, "NF2", type number}) - no any column will be added, but if you do the same without type in the last aggregation - all works properly:

    Table.AggregateTableColumn(aTable, {"F1", List.Max, "NF1", type number}, {"F2", List.Max, "NF2"})

    1 vote
    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 →
  6. Syntax Highlighting in Power Query (Get Data)

    I would love for "Get Data" query editor to use syntax highlighting like the query editor in PowerBI Desktop does.

    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 →
  7. stocks data

    The stocks data is not finding Proton Partners International Ltd (XLON:PPI). I have checked and it shows on Morningstar, which the various posts here would seem to indicate is where the data comes from, but I have also seen a reply saying the data comes from Refinitiv. Whilst I think the stock data is a great addition it is certainly not up to par. There are so many stocks that it can't find or returns from the wrong exchange that it becomes so frustrating to use. Even when you look up the ticker elsewhere and include the exchange and ticker…

    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. stock data

    There only appears to be a Buy price available via the Stockdata icon. Please add the selling price as well, as it is the selling price that is used to value stocks.

    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. Stockticker Update

    Need update for Daewoo Shipbuilding & Marine Engineering Co., Ltd (XKRX:042660) - South Korean stock exchange. Other XKRX stocks are available via the Stock ticker, so why does it not find this one.

    Also no Singapore exchange stocks found, only OTC exchanges. e.g. Oversea-Chinese Banking Corporation Ltd (OTCM:OVCHY) instead of Oversea-Chinese Banking Corporation Ltd (SGX:O39).

    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. As the feature available on Android, I'm expecting that Handwritten Data Table should be converted in Spreadsheet Table !

    The Scanned or picture taken by Cell phone should be converted into Excel Sheet's Table ☺

    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 →
  11. Improve stock data type search

    Some stocks are not easy to search, it would be easier if we could just enter the ticker and market, as there is just one ticker for stock and market.

    Other option could be integrating somehow all the predictive results that Morningstar offers when you start typing. Besides I find somehow difficult to pick the right stock, as sometimes you are not able to select from which market you want to get it.
    For example CVR Partners is not listed when searched and if you search by UAN, which is the NYSE ticker it just finds Yorbeau at German market,…

    6 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. Cut and paste CSV and JSON right into cells rather than import.

    CSV and JSON formatted text is pretty obvious. It would be a lot easier to cut and paste CSV into cells such that each CSV delimited cell becomes one cell in excel.

    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. Please add tickers for S&P 500, Nasdaq and Russell 2000 markets.

    You have !DJI. Please add tickers for S&P 500, Nasdaq and Russell 2000 markets. (They are ^GSPC, ^IXIC & ^RUT at !Yahoo Finance)

    4 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. COMBINING OFDATAF ROM MULTIPLE EXCEL FILE TO SINGLE SHEET

    COMBINING OFDATAF ROM MULTIPLE EXCEL FILE TO SINGLE SHEET

    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. Mongo/Cosmos Data Source

    Experimental plugin that adds option to import data from collections.

    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. 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. Add the bid-ask spread to the stock data type

    Adding the bid-ask spread to the stock data type will inform the user of possible liquidity or sudden volatility issues with a fund.

    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 →
  18. I wanted to extract the data from sheet1 and sheet2 with respect to date using if condition,

    I have 3 sheets named as Generalized sheet, sheet2 and Sheet3,
    To copy data from sheet 2 and 3 based on the date If condition is being used.
    when the 1st if logical value is false another if condition is used (nested if).
    =IF(Sheet3!$A2=Generalized!$K$1,Sheet3!$A$2,IF(Sheet2!$A2=Generalized!$K$1,Sheet2!$A$2," "))

    Sheet 3 has data in 5 cells hence the above formula is working fine.

    When the formula is dragged the cell count increases and hence the formula goes wrong.

    Please help me in solving this

    Solution.
    can we get an update to unlock the cell once the logical condition is false.

    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. 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. Stock Ticker Update

    Stock Ticker Update: Excel needs an update on Adamas Pharmaceuticals, please add it's NASDAQ ticker: "ADMS" and corresponding data. Currently only Deutsche Boerse data is available.

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

Feedback and Knowledge Base