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. [Bug] Multiple instances upon opening multiple Office Documents

    Starting with Version 16.0.8625.2121 of Office (tested with Word and Excel) - when you select multiple documents in the Explorer and hit Enter to open them, you will end up with instances to the count of the previous selected documents.

    To reproduce do the following steps:
    1. Create 2 empty Excel Workbooks anywhere on your machine
    2. Select those 2 files
    3. Hit Enter
    4. Check Taskmanager and you will see 2 instances of Excel

    In earlier versions than 16.0.8625.2121 you would end up with only 1 instance.

    Tested with
    16.0.4266.1003 - pretty old image we had around than we…

    1 vote
    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 →
    • Change a Repeating Block of Data into a Single Row of Data in Power Query

      In Power Query (Get & Transform) create the ability to easily Transform a "Block" of data into a single Row (Record) of data. I want to be able to take 3 Rows of 3 Columns each and Transform them into 1 Row of 9 Columns. Or 6 Rows of 4 Columns each and Transform them into 1 Row of 24 Columns. Etcetera. This type of pattern repeats itself throughout the input data file and each re-occuring block of multiple rows should be iteratively transformed into a single row. For example:

      (Where the "Blocks" are a, b, c...)
      a1 col1 a1…

      1 vote
      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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
      • Support mapping large data sets

        I've tried mapping data sets between 14 million and 90 million rows, imported through power pivot and haven't had any success. Each time I get the error message "3D maps encountered an error and could not complete the last action".

        I haven't had any issue on smaller data sets <1 million. It would be great if Power maps could support large data sets.

        1 vote
        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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
        • Problem with conditional formatting in pivot table (with more than 1270 rows). Excel 2013/2016

          After adding conditional formatting to the pivot table with the format "format all cells based on their values", it works until the table is expanded to more than 1270 rows.
          This problem occurs when the values are in rows, if the values in the columns, it works.

          Example when it works: https://prnt.sc/hcv0u0
          Example when it doesn't work: https://prnt.sc/hcv1jt

          The problem was tested in Excel 2013/2016.

          2 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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
          • Add More Functions to the Status Bar

            First of all, those simple functions that are visible in status bar are amazing. They are quite helpful but I feel that it can do more. Here are my ideas:

            1. Be able to see the difference between values in STATUS BAR. It wouldn't make sense to include the sign because I don't know how it's going to be implemented easily for users, without requiring few clicks. But most of the time, we just wanted to quickly see the ABSOLUTE difference.

            2. Be able to set customized functions (or combination of functions) in the STATUS BAR. For example: EXACT for…

            1 vote
            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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
            • Excel spread sheet tabs are too small

              In Windows 8, we were able to re-size Excel spreadsheet tabs, to make them bigger. I have now upgraded to Windows 10 and the option to increase sheet tab size is no longer available. The sheet tabs are too SMALL! Create the ability to increase the size of sheet tabs, but put the option under File>options>advanced. There is no logical reason why we should have to go into properties, display, appearance . . . in Windows control panel. And I can't understand why you would take away that option in the first place???

              1 vote
              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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
              • 1 vote
                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 →
                • Application errors between Word and Excel linked documents

                  We are using O365 Personal on windows 10 Home Lenovo Laptop.
                  Since November 6th we are facing issue with Word files links with Excel file. When we double click or try to open the link on word file it gives error message as follow "Word cannot open the document: user does not have access privileges".

                  We tried the behavior on new word document copy a cell data from excel file, On word file select past special  past link  MS excel worksheet object and OK. Then Right click on pasted cell  link worksheet object  open link got…

                  1 vote
                  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 THE BUGS with Application.ScreenUpating & Application.DisplayAlerts!It has been reported as broken for over a YEAR

                    BUG REPORT: Neither Application.ScreenUpdating or Application.DisplayAlerts work correctly in Excel 2016. Without these functioning, (unattended) macros are useless.

                    1 vote
                    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
                    • 0 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 →
                      • "Others" Table split option

                        Desperately needs a feature that's not difficult to do: A kind of maximum Output size for PivotTables and other kinds of Summary views. The function should possess the ability to create a set amount of values and/or a set amount of "others" aggregated at the bottom.

                        1 vote
                        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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
                        • Enable coauthoring to work with files stored on Dropbox and other cloud storage providers.

                          Co-authoring works well on Excel desktop in conjunction with OneDrive based files. There is however currently no solution for businesses using Dropbox or other cloud providers.

                          Can we enable co-authoring with these too? Particularly Dropbox.

                          2 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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                          • Create a new formula that return the last formula of a cell

                            Assume

                            formula in B1
                            =IF(SUMPRODUCT((CELL("address")=CellControlTable[CellColumn])*1), DoSomethingFormula(), IFERROR(LastValueInFormulaForm($B$1),""))

                            and focus currently in cell: A1.
                            I change the contents in A1 that its address is in CellControlTable. B1 value is changed by formula in [true part]. Then, i change cell:Z10, which is not in cell control table. In this case B1 keep no changes and the content is still in a formula form.

                            I don't want a macro solution.

                            1 vote
                            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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
                            • Entering a Sngle Cell without entering a whole new row

                              Don't understand why MS Office has changed (I didn't realize that it was subject to updates like Windows is.) My Excel will no longer allow me to add a single cell (or delete one). Now the only choice I have is to add or delete a whole row. Are you kidding me? What is going on here? I've checked Options and I don't see a choice to get back to one single cell insertion. What is going on?

                              1 vote
                              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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                              • On a scatter chart, provide ability to shade the area between two traces

                                Been waiting for this for years... In science or engineering, when the difference between two traces has a particular meaning, the ability to shade the area between them helps greatly in making it clear to an audience. Of course this can be painstakingly done by creating drawing objects to superimpose onto the chart, but as soon as your data changes, the work is lost. Thank you!

                                1 vote
                                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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                                • For document recovery, please display differences between recovered files!!

                                  When Excel "didn't close properly," and upon opening again, it gives you the choice between various recovered versions of the different files that were open at the time of the crash... and these files happen to be huge... there's a very great need for Excel to display the differences between those files. That way you can choose between them without a huge amount of work to determine what's different (there might not be any difference, but you need to know). As a very heavy spreadsheet user (dating from far before Excel even existed), I have a pretty long wish list...…

                                  1 vote
                                  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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Color

                                    I tried a Theme but didn't like the whole idea destroying 10+ years of work. I could not remove the themes and get the color pallet (matrix) I had used since 2003. Note that each cell was setup by conditional formatting and half manually entered. No overall effect could be used.

                                    I need an option to reject all Themes.

                                    1 vote
                                    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Include Mailbox archive access when connecting to Exchange via Power Query

                                      Currently when connecting to a Microsoft Exchange Server as a new Data Source in Power Query, you only have access to the main inbox.
                                      Connecting to exchange to report on an inbox is technically hampered if any archiving policies are in place. This is especially true for a shared inbox where custom policies are setup to archive on a weekly or fortnightly basis on specific folders.

                                      1 vote
                                      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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Maximized Excel won't come to the front when opening pinned file

                                        This just started happening within the last week or so.

                                        1 vote
                                        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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
                                        • This is my idea of how you can delete a space in a file name using Microsoft Word for Excel Here is an example you want to delete the space

                                          This is my idea of how you can delete a space in a file name using Microsoft Word for Excel Here is an example you want to delete the space

                                          Here is an example you want to delete the space between "7" and "amazing"
                                          7 amazing space pictures

                                          You Do Not Have To Do Steps 2 To 6. This is your choice.
                                          I do it to make the page more accurate to read when the job is done

                                          Step 1
                                          Open Microsoft Word

                                          Step 2
                                          Copy contents of the cell or cells from Excel spreadsheet to Microsoft Word

                                          Step 3 …

                                          1 vote
                                          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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 167 168
                                          • Don't see your idea?

                                          Feedback and Knowledge Base