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.

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. Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems

    It's fantastic that you can pick up named ranges in Excel and pass them to Power Query as parameters. However the process is cumbersome and often results in Formula.Firewall warnings or other issues.

    This leads to having to switch Privacy Levels to "Ignore" or having to write a query within a query rather than nice and clean "parameter" queries.

    It would really simplify things if we could quickly create parameter queries (including a drop down to select parameter type) and that these queries would be immune from the Privacy warnings.

    273 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      8 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    • 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…

      218 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

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

        Hello Everyone. We agree with you! The experience you’ve captured here is at the top of our list to address with a future coauthoring feature. I can’t share a timeline for when this will be delivered but wanted to let you know that we do recognize the impact not having this ability has on your coauthoring experience. Stay tuned for more.
        Scott (Microsoft Excel PM)

      • Return share workbook functionality to Excel 2016

        Excel 2016 has recently removed the share workbook functionality and hidden the icon for easily sharing workbooks. It appears that this has not taken into account spreadsheets that are saved on file servers, and aren't uploaded into the cloud (ie the co-authoring functionality). Please return the functionality so that workbooks can be easily shared.

        81 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

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

          You’ve provided feedback on the Excel Shared Workbook experience and we would like to know more about how you’ve used this feature and the value it provides. By taking this survey, you can help the Excel team better understand how to prioritize our Collaboration Experiences moving forward.

          Your input is greatly appreciated.
          Thanks

          https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR3M53G0xM8tHle2rOax4MqNUQ0lOWlM2OFRTTkJNRTVGQU1ZV0hDMTZYSy4u

        • Allow interaction with Excel while in Power Query

          Please make the Power Query editor window (Get Data) non-model. When building complex queries, we often need to go back to Excel to change a worksheet and look at data. Right now, the Power Query editor window takes control over the application, preventing interaction with Excel.

          The current behaviour makes it very difficult to do things like the following:
          -Mid query, go back and check a worksheet to see exactly what a cell value may be that you want to refer to
          -When we have a static table in Excel and are trying to build a query that lands an…

          209 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

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

            Hi Ken,

            Thanks for logging this suggestion. Yes, this could be quite useful. Others that’re interested in this, please do log your votes so we’ll prioritize this work appropriately.

            thanks

            Ashvini Sharma
            Lead Program Manager
            Excel

          • Get Tables working on protected sheets (add rows, sort, filter, etc.)

            I would like to be able to, under the right circumstances, have the ability to add/remove rows of a table which resides on a protected sheet.

            Currently if you protect a sheet you can't insert/delete rows of a table. Even if you unprotect all cells and allow inserting/deleting of rows on sheet protection, it doesn't matter and is completely ignored.

            What I am proposing would have to follow specific rules:

            * Table cells would have to be unprotected
            * Cells below table would have to be unprotected (truly optional † )
            * Insert Rows would have to be specified in…

            739 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

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

              Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

              Thanks

              Ashvini Sharma
              Lead Program Manager
              Excel

            • "Power BI Service" as a data source in "Get & Transform"

              It would be awesome if "Power BI Service" is added as a data source under "Get Data" in "Get & Transform Data" in Excel. Though the source availability is already there with "Power BI Publisher Add-in" but it is buggy and hard to deploy on large number of laptops/desktops. Also, it is practically very difficult to educate down the line users about re-enabling this add-in via COM Add-ins in case it disappears from the ribbon which is very frequent in case of this add-in. We have been struggling with this for a long period of time now.

              Considering "Power BI…

              27 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

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

                Hi Deepak,

                Thanks for logging this issue. I agree this would be quite useful, especially as Power BI is emerging as a hub for business data.

                This request is slightly different than what PBI Desktop does. PBI Desktop essentially provides a Live Connect essentially deferring the model to the service and limiting the experience to visualizations so it’s not importing data into the report. So there’re two possible outcomes you could be looking for:
                1. Allow users to import data into Excel as query tables, just like one can from an external store like SQL Server or Oracle. This provides fine grained data retrieval.
                2. Create a new PivotTable that summarizes data on PBI service.

                The PBI Publisher addin performs #2. Is that what you’re looking for? Or would you rather have #1 if you had to choose?

                Others coming new to this suggestion, please be sure to add your…

              • Make quick measures like in Power BI available in Excel as well

                In Power BI we can easily create quick measures: https://powerbi.microsoft.com/en-us/blog/quick-measures-preview/
                This makes it so much easier for newbies or occasional users to adopt the new technologies, so please add in Excel as well.

                42 votes
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

                  Hi Imke & others,

                  Thanks for logging this suggestion and voting on it. Yes indeed this would be very useful to make it easier and quicker.

                  For those that’d like to get this done, please be sure to register your vote to help us prioritize against out backlog.

                  thanks

                  Ashvini Sharma
                  Lead Program Manager
                  Excel

                • Make slicers visible "On Demand".

                  Allow the user to configure if the slicer is always in view or pops up on-demand. Activation/visibility could be triggered by selecting a visible report filter field or pivot table column header. Alternately, a report filter field could be configured to pop-up a slicer instead of, or in addition to the normal selection box. Another alternate would be to have report filter field style boxes independent of the pivot table range which would pop-up the slicer when selected. Lastly, a slicer selection panel could be added with a list of parameters to choose which would cause the slicer to pop-up

                  32 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)

                    We’ll send you updates on this idea

                    1 comment  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →

                    Hmm.. interesting thought, and I can see how useful this could be!

                    Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.

                    Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.Thanks for the suggestion & the votes!

                    Hmm.. interesting thought, and I can see how useful this could be!Others that haven’t yet registered their vote for the item, please do so to help us understand the relative value of this item vs. the others on our backlog.Thanks for the suggestion & the votes!Ashvini Sharma
                    Lead Program Manager
                    Excel

                  • Python as an Excel scripting language

                    Let us do scripting with Python! Yay! Not only as an alternative to VBA, but also as an alternative to field functions (=SUM(A1:A2))

                    5,952 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)

                      We’ll send you updates on this idea

                      414 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →

                      Wow.

                      Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.

                      Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.

                      We’ll provide updates as we progress on this feature request.

                      Thanks!

                      Ashvini Sharma
                      Lead Program Manager
                      Excel

                    • Be able to protect Power Query with password

                      Now any user can edit and change Power Query connections, it would be very interesting to be able to protect Power Queries with a password.

                      Thanks

                      232 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)

                        We’ll send you updates on this idea

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

                        Hi Joana & others,

                        Thanks for logging this suggestion. Yes, being able to protect your queries would be quite useful indeed for delivering solutions. We’ll prioritize this based on the interest, so if you’re reading this and haven’t voted as yet, please do so.

                        thanks

                        Ashvini Sharma
                        Lead Program Manager
                        Excel

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

                        690 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)

                          We’ll send you updates on this idea

                          110 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

                          Thanks for the suggestion Wyn! Thanks also to all the contributors to this thread for the thoughtful discussion and debate.

                          Of the many lookup function requests, this is currently one of the highest ranking on UserVoice. Please keep the votes rolling in if you’d like to see this, it helps us prioritize new feature work.

                          JoeMcD [MS XL]

                        • Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

                          The Query Editor allows you to easily create Year, Month, Month Name etc, but many people need Fiscal Month Number and Fiscal year

                          33 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)

                            We’ll send you updates on this idea

                            2 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
                          • Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window)

                            In the good versions of Excel (prior to 2007) one could open multiple workbooks in the same window. Now, one has multiple instances of Excel (and every other Office app) whenever one opens more than one document / spreadsheet. Quite stupid.

                            (2016-04-27 Dan [MS] - updated title to fix MDI/SDI usage - they were previously being used "backwards")

                            874 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)

                              We’ll send you updates on this idea

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

                              Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!

                              John, Excel

                            • Add "Run R Script" option to Excel 2016 and Excel 2013 "Power Query" add-in, as it is for Power BI.

                              In July 2016, a "Run R Script" option was added to Power BI Desktop. This option would be a huge benefit to have in Excel 2016 and Excel 2013 Power Query add-in also.

                              204 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

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

                                Hi folks,

                                Thanks for your passion around this. We’ve been discussing this item off and on for some time now and we’d love to get your input.

                                The reason we’ve resisted this is because the R runtime & various packages (and updating their versions) aren’t straightforward for other users to install. This limits sharing such queries across a workgroup.

                                What do you think?

                                For others reading this that’d like us to prioritize this work, please be sure to add your vote since we’re prioritizing our backlog based on these.

                                thanks

                                Ashvini Sharma
                                Lead Program Manager
                                Excel

                              • Have Excel scroll better when there are large cells.

                                If there's a really tall or wide cell, Excel jumps to the edge of the cell when scrolling past that area. This is a big pain when, for example:
                                - trying to position a shape
                                - Trying to grab the edge of the row or column in order to resize it.

                                Excel should just scroll normally without jumping.

                                1,882 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

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

                                  Thanks everyone for all of the passion about this suggestion! The number of votes has increased greatly in the last couple months and we’re taking notice! We’ve got a bunch of other Excel endpoints behaving this way already and we’re evaluating getting it done in the Windows versions sooner based on the number of votes it gets – so keep the votes coming!

                                  Eric Patterson (Program Manager – MSFT)

                                • Make Undo stacks track per workbook instead of globally

                                  Undo stacks are currently global between all workbooks that are open at a given time, so pressing undo on one workbook might undo a change in a different workbook. As someone who frequently has multiple workbooks open at a time, it would be much more helpful to be able to step through the edits made on each individual workbook.

                                  808 votes
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    Signed in as (Sign out)

                                    We’ll send you updates on this idea

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

                                    Thanks again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

                                    John, Excel

                                  • Conditional formatting - Apply to named ranges

                                    Currently if you apply conditional formatting to a named range (i.e.. a range named via the Name Manager or a table style named-range), the value in the "Applies to" column of the Condidtional Formatting Rules Manger will revert the named range to its absolute cell reference.

                                    eg. "Applies to: =Table1[Column3]" becomes "Applies to: =$C$2:$C$7".

                                    Apart from being more difficult to read, it creates other complexities. e.g. if I happen to copy/paste a cell into this range, it creates a mess in the rules manager, creating a new rule for each cell pasted.

                                    e.g. if my named range is 'Table1[Column3]' which…

                                    596 votes
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      Signed in as (Sign out)

                                      We’ll send you updates on this idea

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

                                      Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

                                      Thanks,
                                      Steve (MS Excel)

                                    • Visually show which cells are selected even when another application has focus

                                      Currently, when I select one or more cells and then switch to another application, the boundary box and shading for the selected cells are not shown. Other Office applications exhibit this behavior as well--selection highlighting is only displayed when the program has focus. Many (most?) non-Office applications show the highlighting at all times.

                                      It would be far more useful to be able to glance at the spreadsheet and see which cells are selected, even when working in another program.

                                      442 votes
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        Signed in as (Sign out)

                                        We’ll send you updates on this idea

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

                                        Great suggestion E Bow. Thanks for taking the time to tell us about changes you’d like to see – we’re listening. We’ll take a look at this one. As always, folks should keep voting for the things they like the most – we’ll generally be prioritizing things according to the number of votes they get.

                                        Cheers,
                                        John [MS XL]

                                      • Add ability to collapse field areas in PivotTable Field and Area Side by Side view

                                        With the ability/normal experience of creating many DAX measures in Power Pivot, the Values area of the PivotTable design is now too small to use effectively. Since the Values area only shows about 4 rows it's really difficult to organize fields correctly when try to drag fields around if you've got 10 or more fields in your Values area. (not at all uncommon for Power Pivot users, although certainly not restricted to them.)

                                        With the introduction of slicers, however, we also tend to use the Report Filter area less, and don't usually add as many fields to the row/column areas.

                                        393 votes
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          Signed in as (Sign out)

                                          We’ll send you updates on this idea

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

                                          Hi Ken,

                                          Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

                                          thanks
                                          ash [MS XL]

                                        • Link the min and max values of a chart axis to cell value

                                          It would be nice to be able to link the min and/or max value of an chart axis to a cell reference instead of manual enter the value or the auto function.

                                          880 votes
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            Signed in as (Sign out)

                                            We’ll send you updates on this idea

                                            87 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 6 7 8
                                          • Don't see your idea?

                                          Feedback and Knowledge Base