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

    9 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 →
  2. Make terminology 'intuitive' ; 'Simplify'; 'link data'

    Even the list above - I don't know what a macros and add in is,and every day there is new terminology, vlook ups... I do have some idea of what I wan't to achieve though. How about tailoring terminology for 'jo bloggs' rather than IT specialists - it will still work for everyone.

    I'm trying to combine workbooks and link fields across worksheets so I don't have to update data in each worksheet/ workbook. I'm finding it a very difficult task. Thanks for asking. I can't attach file for security reasons.

    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. merge multiple excel workbooks into one

    I have say 10 excel workbooks and each workbook has 1 sheet each then is it possible to merge all those excel workbooks into one with 10 sheets? As I am not able to find any such option to the best of my knowledge.

    1 vote
    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 →
  4. Data types - Please add an option for the icon position

    Hi there,
    I would like to suggest to have an option where to place the icon shown in cells having a data type.
    Additionally, I would like to suggest for left-to-right reading languages to have the default position of this icon on the right side of the cell.
    This would for example allow text to be placed vertically at the same position compared to titles and therefore give a more uniform visualization in e.g. reports.
    Best,
    Mourad

    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 →
  5. update older versions for stock symbol data, if not i will convert my excel pages to google sheets

    update older versions excel 2016 for stock symbol data, if not i will convert my excel pages to google sheets and use google

    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 →
  6. Pasting Info Into Custom Sort, Custom List Box

    In previous version of Excel, I could copy a line of data from one workbook and paste it into the Custom Sort box of another workbook to pull up the info I needed for a 3rd workbook. Now, the Paste feature is totally disabled in the MS Office Professional Plus 2019. Please bring it back. Creating a custom list does not help me because my list changes every single day. (I am able to paste the list in Word, recopy, and paste it in the Custom List, but I want to avoid this extra step)

    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. How EdbMails helps you to recover deleted mailbox and convert to PST?

    If you are facing any kind of difficulty with converting EDB file to PST format, then you can make use of third party tool EdbMails for the successful conversion of EDB to PST. This is one of the instant solutions for all Exchange database recovery issues with ease.

    EdbMails EDB to PST tool functions admirably with most of the versions of Exchange and Outlook. You are allowed to download the demo version of the tool to use all the features extensively and export 30 items from each and every folder of all mailboxes of Exchange to Outlook PST. This will…

    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. Is it possible to obtain a list of all codes for the "Stocks" data type?

    Is it possible to obtain a list of all codes for the "Stocks" data 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 →
  9. enter data from picture app

    enter data from picture app use Ai to work out and insert formulas not just enter numbers

    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 →
  10. Align MS Project and Excel import and export formats

    Importing and exporting between msp and excel is a formatting horrorshow (starting with msp export including timestamps by default). Cleaning the export for updates and comments, let alone aligning the formatting for msp import (no formulas allowed, file must be closed,...) takes too much time. Finally, wizard column IDs should be exactly the same than what user sees in msp columns (ie. Customised longer name). Takes ages to check and/or test that right setup has been configured and stored

    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. Add Data type by Date for excel


    1. Add World Days by Date


    2. Gold and dollar exchange rates by date


    3. Corporate Income and cost by date


    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 →
  12. prasanth

    prasanth

    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 →
  13. LEAVE IT ALONE!!! WHY DO I HAVE TO WORK AROUND ALL YOUR IMPROVEMENTS THAT DO NOT WORK???

    QUIT FIXING IT - IT WORKS, I SPEND MORE TIME TRYING TO GET YOUR IMPROVED VERSION TO WORK THAN I DO WORKING PRODUCTIVELY. STOP CHANGING THINGS. THERE IS NO VALUE IN TRYING TO FIND WHERE YOU MOVED A FEATURE OR TRYING TO DEBUG A GOOD FEATURE YOU BROKE.

    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. When inputting data on expiry dates for training, include a feature where the spreadsheet notifies you when the expiry date is coming up.

    When inputting data on expiry dates for training, include a feature where the spreadsheet notifies you when the expiry date is coming up.

    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. Why some stocks aren`t available at Office365? Ex. KNRI11, MXRF11, BCRI11

    I am using Excel Office365 (Data - Stock) and some stocks available at B3 are not available for Excel Office365 (MXRF11, BCRI11, KNRI11) - a support person from Microsoft told me it is because Excel Database is not updated. Okay, but it doesn`t make sense, how a Stock Listed in Market is not available? Can you guys include/update it?

    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. Vlook up not working

    I am trying to create a table invoicie with Data on one sheet and charge slip on another sheet but i enter the formula and it keeps return N/A in fields can seem to find out why

    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. 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. In "Data > Get Data > From Web" there should be an option to authenticate using cookies.

    On the Data ribbon, there is option to Import data tables from web pages. But the authentication options for web-sites is pretty limited.
    I am unable to import "private" data in excel from the following URL:

    https://ca.pcpartpicker.com/user/hammadrauf/saved/Gb7tpg/by_merchant/

    I believe that my authentication data is stored in cookies, it is not a form based authentication.

    Thanks.

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

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

    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 →
1 2 9 11 13 20 21
  • Don't see your idea?

Feedback and Knowledge Base