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.

Take a look at the feedback that we are currently working on and what feedback we have already completed.

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

    97 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)

      We’ll send you updates on this idea

      21 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
    • I want to deselect the cell which I copied from after pasting. At the moment, to deselect the cell I copied from, I have to hit Esc button.

      I copied data from a cell.
      I click Ctrl V to paste the data onto another cell.
      But right now, I have to hit Esc button to deselect/remove the dotted lines/take away the focus from the originally copied cell. Does this sound right to you??? N O ! ! ! There is a problem.
      Usually, after copying from a cell, you paste the data onto another cell and the original cell which you copied from gets deselected with no dotted lines surrounding the cell. Also, usually after pasted the data onto another cell, if you start typing in another cell,…

      51 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)

        We’ll send you updates on this idea

        26 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
      • Fix the black and grey boxes that cover the screen when you scroll

        Whenever I scroll too fast in Excel on my PC black and grey boxes appear everywhere and cover what I am working on. This is incredibly frustrating because there is no way to get rid of the boxes.

        This only happens on my external display and it only happens in Excel.

        Please fix this issue.

        https://superuser.com/questions/1053006/excel-grey-and-black-boxes-on-secondary-display

        40 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)

          We’ll send you updates on this idea

          34 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
        • Remove the pointless message “There's a problem with the clipboard, but you can still paste your content within this workbook."

          The message shows up if you run in the background a program that keeps a peek into the clipboard, as for example the "Skype web plugin" and other telephone programs. A possible cause can also be the software "Audials".

          You can find a thread with lots of complaints and a few flimsy justifications and non-answers here:
          https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/clipboard-problem-in-excel-2016/224b2a59-8a0c-4897-baba-a481dd06e085

          The message shows up with Ctrl+C, Ctrl+X, using the Format Painter and only taking whole cells. It does not show up if you copy a part of a cell content.

          Contrary to some Microsoft officials’ posts, the error message shows up multiple times…

          16 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)

            We’ll send you updates on this idea

            14 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
          • Correct floating point bug

            In Excel 97 there was a fix for an issue with floating point arithmetic, specifically, when a value reaches zero as is explained in the "Example when a value reaches zero" section at this link: https://support.microsoft.com/en-us/kb/78113

            However, this does not work in current version when the last operand is a 0. For example, using the example given in the section referenced above,

            A1 = 1.333
            A2 = 1.225
            A3 = -1.333
            A4 = -1.225
            A5 = ""

            =SUM(A1:A5) gives the correct answer = 0

            However, if A5 = 0 instead of being blank, then the sum returns -2.22045E-16

            After investigating…

            15 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)

              We’ll send you updates on this idea

              5 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
            • 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.

              14 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)

                We’ll send you updates on this idea

                1 comment  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →

                We’d love to get samples of these workbooks that are crashing, along with steps that cause them to crash. Until then, there’s not much we can do without more data.

                If you have such a workbook, please create a new idea entitled “I have a workbook that crashes, which I want to send you” and I’ll get back to you with an email address where you can send it so we can take a look and fix the problem.

                Thanks!
                Dan [MS]

              • Currency correction for Nigeria from NGN or N to ₦

                Excel is the number one business intelligence tool out there. So with this comes a responsibility to get defaults right. It isn't a coincidence that almost everyone uses Arial and now Calibri as their default font.

                Currency symbols is another one. The Nigerian currency's correct currency symbol is ₦, but this isn't available because there is yet another major error in the regional setting in the control panel.

                Nigeria has about 400 + Languages with three major ones like you have rightly identified (Hausa, Yoruba and Igbo) (Have no idea why Hausa is termed Latin, Nigeria!. Anyway, the issue is,…

                13 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                • 7 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                  • Fix mouse scroll in tables from power query

                    Somehow mouse scroll does not work in tables created from power query. It does work if you alt tab out, and back into excel though. But please fix this issue.

                    7 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                    • Not responding!!!

                      Not responding most of the time, especially half way through, and suddenly all files became "not responding". The only way is to go to Task Manager to End Tasks. Meaning, most of the work will be lost and wasted.
                      Wonder if Microsoft can pay (Using Money) us back with such valuable data lost?
                      Constantly saving files is one thing but we don't know when (everytime using) it will freeze.

                      7 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

                        6 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                      • Wrong cell selected after scrolling in spreadsheets attached to OneNote

                        When you open a spreadsheet attached to OneNote, if you scroll down using a touchpad or touchscreen gesture rather than the on-screen sliders, then click on a cell, the wrong cell is selected. For example, if I scroll two rows downwards (using a touchpad gesture), then click on a cell, a cell two rows above the cell I clicked on is selected instead.
                        Please fix this bug. It has been present since Excel 2013, and is still there in Excel 2016.

                        5 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                        • Excel alerts in a confusing way when opening password protected files from SharePoint

                          When opening a password protected file in Excel Desktop for Windows, it says The file is locked for editing by another user and the prompt button is to save as with no indication that the initial text is clickable to move you to the file tab and choose Check Out from there. And if one does successfully navigate this hurdle and check out the file, the alert DOES NOT GO AWAY. It appears to my users (and to me and I do this for a living) as if the file is still read only as it says in the Title…

                          5 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            2 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                          • Correct status bar calculation

                            Status bar calculates according to formatted numbers in cell. So, if there is a number format :
                            # ##0.00;[Red]# ##0
                            and you enter -2
                            the sum in status bar will be : 2

                            5 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

                              3 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                            • when saving Excel Files on a networkfolder it will be saved with a strange extension xlsx.sb-

                              The permisions for the user to access the server are not the problem, there are no other issues with creating files or opening / saving files.

                              The name of the temporary folder contains the name of the orginal file followed by a lot of numbers and letters.

                              The original file has the name: 'Test 2016',
                              the temporary map: 'Test 2016.xlsx.sb-f535ac32-iM6gfn'. But the next time the last part of the letters and numbers are different. The bold part stays the same.

                              Every time you save the file it makes an other empty folder.

                              Seems to have appeared after last Office 2016…

                              5 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

                                0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                              • Please fix =IRR generating #NUM! error with large numbers

                                I have a series of cashflows, mainly with negative IRRs which mostly generate #NUM! errors. The numbers are very large as they are expressed in Vietnamese ****, so are in the multi-billions. In some cases a very minor change (ie of a few ****) will allow IRR to generate correctly. I increased the number of permitted iterations (to >1000) and the Maximum Change, with no effect. Guesses very close to the actual IRR were little help.

                                It was fixed by dividing all numbers in the cashflow by 1,000,000. But it would be much better if Excel could work with large…

                                5 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  4 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                                • Improvement suggestion for handling single quotes in csv filenames

                                  Hi there,

                                  first, I was a unsure, if I had to post the following into the category "Application error" or "Opening and saving files". As Excel produces a file repair, I opted for the category "Application error". Hope, this is the right one.

                                  If you open a CSV file in Excel, then the sheet name is set to the CSV filename. For example if the CSV filename is Orders.csv, then the sheet name becomes Orders. You can then save the CSV file as XLSX file for getting full Excel functionality. All fine here.

                                  Now, Excel does not allow all characters…

                                  5 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

                                    0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                                  • VBA ScreenUpdating-Property does not work in Excel 2016!

                                    The VBA Application.ScreenUpdating-Property does not work properly in Excel 2016 / Win 10. See attached screenshot. The screen is updated after each step in VBA, although the ScreenUpdating is set to False. The property worked nicely in Office 2007 / Vista.
                                    It would be nice to have this bug fixed as quickly as possible, since I have hundreds of Makros who depend on this property.
                                    Christian Klug
                                    Düsseldorf, Germany

                                    4 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

                                      1 comment  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Fix the "Auto-Save Has Been Suspended for this Session" bug

                                      Seemingly randomly, Excel will decide to pop up this error message. Once it happens, I know I'm screwed because any attempt to save the workbook will fail. The only way to prevent from losing changes is to copy them to a new workbook, save that workbook and then restart excel and copy changes back into the origin workbook.

                                      This happens with huge spreadsheets and small ones, and I've even seen it pop up when I was not interacting with Excel at all. I.e. I was in a different application at the time, so I don't have a solid repro. That…

                                      4 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

                                        0 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Excel 2016 Bug with Cursor - Right to Left Languages

                                        I have several computers. two of them is with Windows 10 and Office 2013/2016.
                                        I noticed a bug with the typing cursor.
                                        I use both English, a left-to-right language, and Hebrew, a right-to-left language, and each has a different typing cursor, a straight line ( | ) for left-to-right and a "hyphenated" line ( `| ) for right to left.
                                        The problem is that in Excel 2016, the moment I switch my language to Hebrew and type something, it locks the cursor in the right-to-left configuration, even when I switch back to English, which gets very confusing, since the appearance…

                                        4 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

                                          3 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                                        • vba code window scroll bar not working under windows creator edition

                                          the vba code window scroll bar has stopped working in the after the creators update. I can use the wheel to move the location, but I can't selcect the drag button on the scroll bar.

                                          The other windows in the vba are fine and work as expected

                                          4 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            3 comments  ·  Application Errors  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 6 7 8
                                          • Don't see your idea?

                                          Feedback and Knowledge Base