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. Power Query - cache shared nodes

    Update Power Query in Excel to take advantage of caching in cases where a parent node refers to a child node that has already been refreshed (as exists in Power BI desktop today).

    This issue creates significant performance problems with refresh times when creating highly interdependent financial and operational models. This is a show stopper from a usability and customer acceptance standpoint.

    1,975 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    Hi all,

    We are happy to announce that the feature is finally available on Production starting from July fork (build 16.0.10726.*) for Office 365 subscribers.

    Thank you all for your votes and the feedback.

    - Excel Team

  2. No more warnings about saving as CSV, especially when I didn't change anything

    I don't know how many hundreds (thousands?) of times I've told Excel that, yes, I really truly do mean to save this file as a CSV. I recognize that not all users will understand that CSV doesn't do cool formulas or formatting, etc., but I do and I still want to do it. And I want to do it a lot. Please, give me a way to opt out of these useless warnings!

    1,196 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    108 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    2016-09-07

    We’re done – you should no longer get a warning dialog about data loss when saving a file as CSV, as long as the file was originally opened as a CSV file.

    Instead, we’ve added a non-intrusive business bar (that you can ignore if you choose) that let’s you quickly Save As the file if you have made changes that are not savable in CSV; if you ignore it and just Save, we’ll just save out the CSV values as you’d expect.

    We actually rolled this out starting on August 13, 2016 with build 16.0.7167.2040 for O365 users. Later builds have this update as well of course.

    Thanks for participating in UserVoice – we definitely value your input. You can now use whatever votes you’d allocated for this idea for other ideas.

    Cheers,
    Dan [MS]

    = started status 2016-06-15 =

    Great news – we’re working on this…

  3. Increase the 218 character filename length limit to open files in excel

    Excel can't open files with full path lengths greater than 218 characters as documented in https://support.microsoft.com/en-us/kb/213983. This is still a problem in Office 2016. It seems crazy that Excel can't open a valid file that the filesystem allows. People have been complaining about this since Office 2000. The thread below has over 11 thousand views and there are plenty others. Please fix this. http://answers.microsoft.com/en-us/office/forum/office2013release-excel/sorry-unable-to-find/595333d0-1463-499f-967e-4da8ac2e2047

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

    We’ll send you updates on this idea

    292 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    I am excited to announce that we have completed the work to enable longer file name and paths in Excel for desktop. This was a significant change that required work on multiple parts of the product beyond open and save, since the file path is used in other features like external links.

    Before this change, Excel for desktop could open and save files with a full path length of up to 218 characters.

    Starting a few weeks ago, all Office 365 users in the monthly channel (CC – current channel, build 12624.20466 or above) are able to open and save files up to 2034 characters. However, in practice there are lower limits imposed by the file system:
    - Windows local and UNC files: 260 characters
    - OneDrive/SharePoint files synced to the local drive: 260 characters
    - OneDrive/SharePoint files opened directly from the cloud: 400 characters

    Thanks again for your…

  4. Make a simple safer version of VLOOKUP and INDEX MATCH

    The majority of Excel users use VLOOKUP to get exact matches from a row or column, It would be good if they all used INDEX MATCH but it's more complex so how about this simpler version for the masses.

    =GETMATCH(ReferenceToMatch, MatchColumn/Row, GetColumn/Row, Optional Value if no match)

    If seen a few other references to updating VLOOKUPS and there are lots of opportunities, but it would be good to address the simple most widely used issue first.

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

    We’ll send you updates on this idea

    128 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Filtering Needs to Work in Co-Authoring

    Say that several people are editing the same workbook. If Tom filters to show only his records, then the other people will only see Tom's records. We need to be able to have each person apply a different filter and see only their records.
    Note that it is fine to require that the workbook can not have SUBTOTAL or AGGREGATE functions in order for independent filtering to work. If you allow these functions, then everyone will have different calculation results which would be problematic.
    It is more important to us to be able to have each person apply a local…

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

    We’ll send you updates on this idea

    76 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  6. May 2017 update which keeps the copied item active in the clipboard

    Regarding the issue of...It's part of the May 2017 update which keeps the copied item active in the clipboard even if you do things that would normally clear it, like typing in a cell, applying formatting, etc.

    Pressing ESC will clear the marquee/dancing ants.

    Why in the world would Microsoft and an extra step here. This is terrible. At least give us the option to turn off the function. Please change this back or give us the option. Very disappointed!

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

    We’ll send you updates on this idea

    541 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    Keep the Copy was designed to improve the experience of copying content to your clipboard based on customer requests. Copy and Paste functionality is different in Excel than most other applications because results from formulas can change and due to the large size of worksheets. Since making the improvements there has been mixed feedback about the changes that we made and it is not up to our quality standards. Effective today, Keep the Copy will be removed from Excel until we have improved the quality and design of this feature.

    Thanks,
    Eric Patterson
    Excel Program Manager

  7. Allow users to set/choose defaults (via settings) for PivotTables - Layout (compact, tabular, classic, etc.), PT Options, etc.

    Excel 2007 introduced the new Compact Form and made it be the default for all future pivot tables. With this layout, multiple row fields are compressed into column 1 of the pivot table. This makes the data very difficult to later re-use.

    My request is to add a setting in Excel Options where each person can choose their default pivot table layout. All future pivot tables will use Tabular, Outline, Compact, or Flat. (Flat is a new layout introduced by Power Pivot... it is Tabular with no Subtotals).

    Additionally, the same settings area shouls allow the user to save other…

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

    We’ll send you updates on this idea

    78 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  8. Make Power Pivot available in all versions of Excel

    Previous title: "Make the Power BI Family - PowerPIvot + PowerQuery + PowerView and PowerMap available in all versions of Excel".

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

    We’ll send you updates on this idea

    257 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

    Hi folks,

    We’re happy to report that Power Pivot is now in all current Windows editions of Excel, including Office 2019 (perpetual) and Office 365 (subscription).
    In older versions of Excel (Excel 2013, Excel 2016) only certain Windows editions (Pro Plus and higher) include Power Pivot.

    Thanks for helping us to make this a reality!

    Vai
    Excel Program Manager

  9. Enable user to pin Folders to the recent lists for Open and Save As

    ** Please bring back functionality from the old Microsoft Office suites (not just xls).

    ** For alphabetic sorting of files in the recent lists, please don't vote here. Instead, see https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10261443-recent-files-pane-in-excel-2013-was-pretty-good-b

    Specifically: it is useful to have a list of recently-accessed folders from which to open files. Such folders were available on the older versions of Microsoft (MS) Office, but not in the 2016 “upgrade”. (i.e. MS Office 2016 contains only a list of the recently opened files.)

    Constantly having to navigating BACK to a recently used folder to open / save a file is very annoying.

    I'm not the…

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

    We’ll send you updates on this idea

    58 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  10. Add icons for font superscript and subscript so we can put them on the QAT

    Word has direct access (with icons) on the ribbon for subscripting and superscripting characters, but Excel can do so only via the Home...Font menu item. Scientists and engineers need to use subscript and superscript characters when writing mathematical and chemical formulas. Please copy the subscript and superscript icons in Word, and make them available to the Customize QAT feature.

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

    We’ll send you updates on this idea

    74 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    Starting with the June release of Excel, you have:

    Quick access to superscript and subscript!
    Keep the superscript and subscript commands at your fingertips by adding them to the Ribbon or Quick Access Toolbar.

  11. AutoSave Master Switch rather than an "I Told YOu So!" later

    Microsoft has added a new feature to help users co-author files. Whether you are for or against this feature is not my point here: it needs Excel's AutoSave switched on to work. That's fine. But it shouldn't be the default. It is accepted that Office is trying to make various apps consistent, but Excel is used differently. What makes it the most popular software in the world is the ability to experiment without consequences.

    Made a mistake? No fear, close without saving and re-open. Accidentally delete a sheet? Don't worry, close without saving and re-open. Replaced all formulae with =RAND()?…

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

    We’ll send you updates on this idea

    72 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    We have been listening to your feedback and are updating AutoSave with the ability to turn AutoSave off if desired. There are three patterns in this feedback thread that we are addressing now. The first pattern is that you want AutoSave off because you make temporary edits or hypothetical edits that you don’t want to save (we call this what-if analysis). The second pattern is that you start a new file from an existing file after making some changes to the existing file (like a Template or Invoice). The third is that sometimes the “Last Modified” timestamps are changing even when no edits were made.

    In response to the feedback about a desire for AutoSave to be off by default due to temporary or hypothetical edits (what-if), we have added some new functionality and options for AutoSave:
    1. You can turn AutoSave off for a specific file. While a document…

  12. Unselecting cells when using Ctrl to select multiple cells

    When using Ctrl to select multiple cells, we can't unselect a cell when it was misclicked. Instead, we have to click these cells all over again. Please allow us to unselect cells!

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

    We’ll send you updates on this idea

    20 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  13. Translate XLOOKUP and XMATCH to PROCX and CORRESPX in Portuguese

    That's it: PROCX and CORRESPX in Portuguese versions of Excel to keep the same standard of the other functions.

    🇧🇷🇵🇹🇦🇴🇲🇿🇨🇻

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

    We’ll send you updates on this idea

    29 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Enable collaboration with others editting in Excel desktop

    In Word and PowerPoint you can collaborate from the desktop as well as online. In excel, whenever anyone opens the document on desktop others get locked out of editing and can only view. This is a problem for our organisation since occasionally remote team members need to edit the file on desktop but failure to close down the document properly (either accidentally or because the OS somehow did not release the file lock which has happened on Mac's) means the entire team is suddenly unable to work for extended periods until we track down the culprit.

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

    We’ll send you updates on this idea

    92 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Collaborating in Excel has been available for current channel users, starting with version 1707 and version 1808 for Semi-Annual users

    Note: This feature is only available if you have an Office 365 subscription

    If you are an Office 365 subscriber, make sure you have the latest version of Office.

  15. Support saving CSV in UTF-8 encoding

    Currently, if I create a CSV file with Excel, it can only be saved in ANSI format, turning all special characters to garbage. I would like to be able to save it in UTF-8.

    I know I can save it in the "unicode text" format, but the problems with that are:
    1) It uses tabs instead of comma.
    2) The encoding is not UTF-8, making it alien to other applications.

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

    We’ll send you updates on this idea

    34 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    2016-11-01——————-

    Great news here folks – we’ve completed our work on this feature and Excel will support a new CSV format using UTF-8 encoding.

    This fix still needs to make it through our release pipeline, but you should see it as an option once you have a build equal to or later than 16.0.7466.2023.

    Cheers,
    Dan [MS]

    2016-06-28———————-
    Good news – we’ve started work on this.
    Cheers,
    Dan [MS]


    older——————-
    Thanks for the suggestion Doron. As Dan mentioned in the comments, we’re watching this one. I’ve seen a number of other suggestions related to CSVs as well. We’ll keep our eyes open here and take a look at the highly voted things in this space. As always, keep the votes coming to help us do a good job prioritizing your favorite asks to the top.
    Cheers,
    John [MS XL]

  16. When copying tabs, somtimes we have to cycle through 100s of "Yes" or "No" to the "Name already exists warning" Can we add Yes to All option

    This is a major productivity killer for power users such as finance teams, and current UX does not help exit this state efficiently.

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

    We’ll send you updates on this idea

    29 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →

    Thanx for all your feedback and voting folks!

    You should see a “Yes to All” option in the “Name Conflict Dialog” from O365 version 1907 onwards. https://docs.microsoft.com/en-us/officeupdates/monthly-channel-2019#version-1907-july-29

    Also, the “Name Conflict Dialog” article have been updated accordingly: https://support.office.com/en-us/article/why-am-i-seeing-the-name-conflict-dialog-box-in-excel-f9251985-dbde-4030-86d8-e90775e79952

    Please let us know if you do not find this to be the case.

    thanx,
    Prash
    [Excel Team]

  17. read only mode

    Excel 2016 workbooks open in read only mode from SharePoint and Edit needs to be enabled everytime.

    I open and edit the same workbook 100 times every day. I wish that I could open the Excel without clicking the Edit button every single time.

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

    We’ll send you updates on this idea

    53 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →

    Excel in the Web now opens all files in edit mode by default. If you continue to experience the file opening in read-only mode it’s possible one of the document authors set the file to open as read-only recommended. This can be changed from the File menu, Info, Protect Workbook and Deselect Always Open Read-Only.

    Thanks,
    MS Excel Team

  18. Maintain copied data on the clipboard even if the "dancing ants" aren't shown around the copied range (Copy-paste clipboard persistence)

    If I copy [ctrl-c] a cell, then type in another cell, then try pasting, no result. No paste. It would be nice if Excel would maintain the copied data on the clipboard even after the dancing ants no longer appeared, so that I could paste that data.

    (2015-11-05 Dan [MS] - updated idea title and description to be clearer)

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

    We’ll send you updates on this idea

    78 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →

    Starting with the Excel release available in June, Excel “Keeps” your copy longer. You can Copy your cells, and before you paste, you can still do other tasks like typing or inserting cells.

    Based on customer feedback, the dotted “Marquee” stay active for much longer so that you can type, add formatting or many other things before the paste operation. We also made both the “Insert” and “Insert Copied Cells” commands available after the copy operation. Now, if you are copying data to another worksheet, only to realize you need more room, you can insert a variable number of cells and then paste without having to re-copy the original range!

    If you want the Marquee to disappear, you can use the ENTER key to perform the paste operation, or after the paste, you can press the ESC key to cancel the copy.

  19. Recent Files pane in Excel 2013 was pretty good, but Excel 2016 broke it (Pin pinning recent files no longer sorts alphabetically)

    In Excel 2013, you could pin recently opened files to the top of the list, and they would be sorted alphabetically. This way, you could easily get the same file by using keyboard shortcuts. For example, Alt-F-R-1 opened the first one on the list, alphabetically. The order stayed constant until you pinned or unpinned a file.

    In Excel 2016, the files are listed chronologically, so Alt-F-R-1 opened the most recently used one. If you wanted to get a certain one, you have to wait to see where it is in the list. This is a TERRIBLE change. I keep opening…

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

    We’ll send you updates on this idea

    167 comments  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →

    = 2016-12-09 =
    Hi all,

    The MRU should be sorting alphabetically again if you’re using build 16.0.7466.2038 or later. You can find your build number under File > Account.

    Cheers,
    Dan [MS]

    = 2016-09-22 =
    Hello,

    I noticed a few reports of folks not seeing alphabetized MRUs anymore so I followed up with the Office team (it’s shared across Word, Excel, PowerPoint, etc.) that owns this.

    Turns out that they rolled it out in July (and then we posted here that the work was completed) but then ran into some bugs and so disabled the feature on the MRU-service side.

    That bug has been fixed, and they are planning to roll it out again in October.

    Cheers,
    Dan [MS]

    = 2016-07-11 =
    Greetings,

    Good news on the recent files front – pinned files are now sorted alphabetically, as they were in previous versions of Office (and Excel).

    To see…

  20. Remove the lock symbols from the tabs of protected sheets

    Microsoft appears to have added this as a new 'feature' in Version 2006 (Build 13001.20266 Click-to-Run) and it's a disaster. For a workbook with a large number of protected sheets the visibility of sheet tabs is reduced by ~ 30%, thereby greatly reducing user-friendliness and the ability to navigate around the workbook using sheet tabs.

    I've attached a screen grab of a basic model containing protected sheets which has lost visibility of at least 3 sheet tabs as a result of the unnecessary and unwanted lock symbols on almost every sheet.

    This 'feature' needs to be removed or made optional…

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

    We’ll send you updates on this idea

    210 comments  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →

    Hi All, We apologize for being slow to engage on this thread. We are listening to your feedback and we really do care. After reading the comments here as well as the feedback sent from within Excel, we have decided to remove the lock icon from Excel on Windows for the time-being. Since it’s not new to the other platforms (web, Mac and mobile) and we haven’t had similar feedback about it there, we won’t change those for now. We’ll consider how best to get consistency across the desktop, web, and mobile apps, and we’ll share updates if we have any additional next steps.

    We appreciate all the suggestions for alternative ways of indicating that a sheet is protected, and will take them into account.

    Thanks for all your feedback.

    Steve [Microsoft Excel]

← Previous 1 3 4
  • Don't see your idea?

Feedback and Knowledge Base