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

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

  3. make excel 2016 as stable as previous versions

    Make Excel 2016 as stable as previous versions
    We run complex spreadsheets with conditional formatting and links between spreadsheets and macros to drive behavior - this is both inherently slow (on various different computers) and unstable - crashes almost daily
    Previous versions of Excel handled these same spreadsheets cleanly and easily !!!

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

    We’ll send you updates on this idea

    26 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you all who voted! And we hear you loud and clear and we have been working hard at improving Excel 2016 stability on-going with every monthly release with our January monthly channel release at historically low levels based on our internal measures.

    Moving forward, please send us feedback from within Excel, which includes actionable crash information we monitor regularly. Once Excel reboots from a crash please goto File → Feedback → Send a Frown, provide information on what Excel specific action you were doing when the crash occurred and press the “Submit” button.

    thanx,
    Prash [MSFT]

  4. let pen usage toggle between inking and pointer

    The January 2016 Office update defaults the Surface Pen to an inking tool. Most Excel users prefer to use the pen as a pointer. Please give us a toggle in the ribbon to switch between inking and pointing.

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

    We’ll send you updates on this idea

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

    (2016-03-15 – Completed) (Edit: Added link to Office Insider signup)

    I wanted to let everyone know that in the update to Office that started rolling out to Insiders today, you will find a new preference in the Options dialog to allow you to make the pen select instead of ink by default. Enabling this preference will make the pen function exactly like it did before, plus you can use the options on the Draw tab if you do decide you want to ink. If you are an Office Insider (which anyone can join – https://products.office.com/en-us/office-insider), you should get this update within the next day or so. If you are not an Office Insider, it may take another week or two to reach you.

    This is a per-app preference, so you can enable selection by default in Excel for instance while leaving ink as the default in Word and PowerPoint,…

  5. 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 →
  6. Stop Auto correcting certain words

    Just as in Word when you type: i.e ihs, it will auto correct to "his" but it will place a little grey bar under that word that has a pull down menu allowing an option "Stop automatically correcting this word." Excel does not have that feature, must enter auto correct menu and use the exception menu to place it on the list. Change Excel to have same options as Word.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →

    We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been greatly improved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.

    This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you…

  7. Disable time grouping

    The new automatic time grouping in PivotTables should be an option within Excel. Users should not need to make a registry edit to disable this feature, and the time grouping should not be on by default.

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

    We’ll send you updates on this idea

    completed  ·  80 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  8. Allow PowerQuery to Extract Data from PDF tables

    Allow PowerQuery to import tables of data from PDF files.

    99 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 →
  9. 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 →
  10. 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…

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

  12. Scroll horizontally by pressing Ctrl+Shift+Wheel scroll, or with mice that support side scroll, like Adobe Reader, Chrome, IE...

    Scroll horizontally by pressing Shift+Wheel scroll, or with mice that support side scroll, like in other aplications, like Adobe Reader, Chrome, IE...

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

    We’ll send you updates on this idea

    53 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    Good news! On Windows, you can now scroll right and left using a mouse with a scroll wheel by holding down CTRL+SHIFT. If you move the scroll wheel up, it will scroll your sheet to the left, and scroll down to go right. On Mac, you can just hold the SHIFT key to do the same thing.

    To see all the suggestions we’ve completed, please see https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/filters/top?status_id=1406092

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

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

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

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

  17. Better testing with large, complex workbooks

    I work with a large, complex workbook (several MBytes, about 150 worksheets). Excel crashes several times per day, and even crashes Windows 10 regularly with a stack overflow. Simple VBA code that works with small workbooks will regularly crash Excel (e.g., For Each ws In wb.Worksheets; do something simple; next ws). I suspect that the problems are memory or stack related, but my real request is for the testers to specifically create test cases based on huge workbooks, then see what happens.

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

    We’ll send you updates on this idea

    1 comment  ·  Flag idea as inappropriate…  ·  Admin →

    Over the last few years, we’ve improved our ability to detect and fix performance issues significantly, and as a result we’ve seen performance improvements for users as well.

    We intend to continue working on performance, but we’re marking this suggestion as completed.

    Steve [Excel team]

  18. Excel 2016 crashes with large sheets and filtering

    When opening a large file and start filtering, work with that filter, use a second filter dn remove one of the filters Excel crashes

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

    We’ll send you updates on this idea

    99 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all, the original issue reported in this thread was due to Win10 changes in Accessibility. The fixes for this have been released for Excel 2013, Excel 2016 and Office 365 subscribers in March.

    For more information, this thread has the discussion: http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/excel-filtering-problemmatic-after-windows-10/f6f34982-d4e0-47b3-bd37-772fd51e0ff3.

    thanks
    ash

    Ashvini Sharma [MS]
    Excel

  19. HTML formatted files (with an XLS extension) no longer opened

    Since a recent update HTML formatted files with .xls extension are no longer opened. When downloading such a file Excel opens but does not open the file anymore, it just shows a blank screen, no error message. This used to work for years and was very easy to create reports from our intranet by just sending HTML files with Excel headers out. Because of this we now have to re-engineer all reports, please bring the functionality back.

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

    We’ll send you updates on this idea

    4 comments  ·  Flag idea as inappropriate…  ·  Admin →

    Hi all,

    We’ve released a fix for this issue. I’m copying the official release notes for it here, as this is part of several different updates to several different versions of Office:


    The Excel team has released a change in behavior in today’s security update for Excel 2010, 2013, and 2016. Excel will warn about the mismatch between the file extension and HTML content, but will now open the workbook in Protected View as an additional layer of security. If you trust the workbook, you can then enable editing. The behavior of .xla and .xlam files will remain the same.

    How do I get the update? It depends on which version of Office you have.
    • Office 365 subscription (Click-to-Run)—install the latest updates
    • Windows Installer version (MSI)—you could wait about a week for the next security update for MSI, and it will update automatically. Or, to…

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

  • Don't see your idea?

Feedback and Knowledge Base