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

    27 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 →
    • Interoperability problem with Excel Online

      I'm sharing a rather basic Excel 2016 file I've created with some other people so that they can enter data into it using Excel Online.

      Very frequently, I'm facing the following issue: some cells containing (integer) numbers with the "General" formatting style have their formatting changed to "Accounting" resulting in "1" being displayed as "€ 1.00". If I fix this from the Excel 2016 side of the equation, it comes back some time later.

      I'm unable to repro this by editing the file myself via Excel Online (I've tried using https://1drv.ms/x/s!AjBPRo9wXw9s2eZp7PUayA9Pg1rHaw), so it must be linked to some of…

      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

        1 comment  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
      • Please return "Share workbook" back

        Please return "Share workbook" back!
        We will not use OneDrive and any other cloud storage according to our corporate security policy and Federal Law that protect personal and medical data!

        P.S. It's also impossible to unprotect existing worksheets for already shared files!!!

        17 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  ·  Collaboration and Sharing  ·  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.

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

            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

              1 comment  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
            • Autosave in Office 2016 (NOT Office 365) to enable Co-authoring

              Autosave feature doesn't seem to be enabled in the DESKTOP version of Office 2016 when bought as a one-off licence (instead of buying Office via 365 subscription). This means we can't use Co-authoring.
              I have Office 2016 Home and Business installation Version 1709 Build 8528.2139 Click-to-run. 3 licences on 3 PCs in my office.

              I have Office 365 Business essentials subscription giving us Exchange email, Onedrive, Skype etc on my 3 PCs.

              I have previously used the "share workbook" feature to for multiple users to have an Excel spreadsheet open and modify simultaneously.

              Microsoft are deprecating this function and suggest…

              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

                1 comment  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
              • Allow Templates to be Posted Online Behind a User Paywall

                Many of us create templates that we would like others to be able to use and access, but due to the extraordinary amount of work and updating that is necessary to keep the template relevant today, it would be helpful to allow users to post templates behind a pay wall and perhaps be able to create a small business for themselves that could be enormously helpful to others. This would encourage many out there who are currently hoarding their spreadsheets and templates to share with others, thereby making everyone better off. And to avoid concerns regarding inproper copying, the spreadsheets…

                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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                • Co-author

                  In collaboration/co-authoring situations, allow worksheet_change events that add additional data to a worksheet to be uploaded/updated to all users without the need to refresh the workbook.
                  Also allow userforms that add data to work in the same way.

                  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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                  • There is no way to "pin" a Javascript Task Pane Add-In on a specific Excel Document

                    There is no proper way to "pin" a javascript Task Pane Add-In (from the Office Store or from an organizatioal source) to a specific Excel File. This should easily be possible by saving an Excel File with an open javascript Task Pane Add-In. If this file is opened by another user, the taskpane add-In should be added (if not yet done) and opened automatically. If the Excel file is saved without the open javascript add-In, then it is not pinned to the Excel File. This should work in all plattforms: Excel 2013, Excel 2016 Excel for Mac and Excel Online.

                    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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                    • Allow autosave/co-authoring for password protected workbooks

                      When using co-authoring with Autosave in latest Excel desktop client, it fails if the workbook is password protected. Allow multiple users to edit a password protected workbook.

                      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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                      • Enable data query refresh (with PowerPivot tables) when workbook structure is protected

                        I want to protect the queries from being changed but want users to have the capability to refresh the data model (that uses PowerPivot).

                        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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                        • DISABLE DOWNLOAD BUTTON ON EXCEL ONLINE WHEN SHARE VIEW ONLY LINK

                          complete joke as I wasted hours trying to find the proper config because I thought, how was it that with all the gains in o365 that has taken place Microsoft actually thinks this is anything close to an acceptable status quo. VIEW only links are WORTHLESS if the recipient can download my file.

                          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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                          • Bring back 'Send' as a default instead of 'Share'

                            The new 'Share' options, and specifically trying to default everything to OneDrive is terrible.

                            Adding clicks to sending traditional attachments to try and push your cloud storage garbage is driving away my organization.

                            More to the point, these new 'updates' that happen literally in the middle of the workday and change basic behavior within Office apps is the worst idea in Microsoft history, possibly behind Win ME and RT.

                            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  ·  Collaboration and Sharing  ·  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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                              • Excel Collaboration and Sharing

                                Issue:
                                There are many times where my co-workers and I are required to work in the same spreadsheet simultaneously. The excel web application allows us to do this but does not contain the full functionality of excel that is required to do our work. Although Excel already has as shared spreadsheet option, each time a user wants to see updates, they have to save and hope the other person saved their updates as well.

                                Solution:
                                It would be great to use excel and collaborate in real time just as the web app does but within the excel platform on our…

                                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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                                • Use Mac Address for sheet protection

                                  Many more are now realizing that the excels protect capabilities are not so good. How about using a computers MAC address to protect documents. Not VBA, not passwords but the physical address of a computer. I know people can spoof this though but wouldnt it take some real pc wizards to do so and people who are really trying to get into a document to edit it.

                                  The point is so that we can safely distribute and time expire excel documents and only let certain people view and edit what we want them to and hide everything else.

                                  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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                                  • Change default for new 'Share' function in Excel 2016

                                    When I click the Share button on the top right, aside from it being a little slow, I would like to customise the default option that's presented.
                                    You currently are given the options:
                                    -Anyone
                                    -People in your organisation
                                    -People with existing access
                                    -Specific People.

                                    When I click it I am defaulted to 'specific people', whereas more often than not I am sharing a document to a Group member who already has access rights, but needs to be pointed in the right direction.

                                    I realise this isn't the case for everyone, but it would help m y workflow a lot to…

                                    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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Problem in Excel filtering in Co-Authoring mode

                                      When many persons edit a shared excel sheet in co-authoring mode and sheet have filters on any columns then:

                                      now when one person filter data in column this filters is apply in each other person in their desktops excel sheets. Thats way other persons have filtered columns with hidden data that they not want to hide and need it to proccess.

                                      Solution (like a A-Tools):
                                      every person can filter column data localy for a her own desktop, that not apply to other desktops.

                                      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 →
                                      • Cambiar de Mayuscula a Minuscula

                                        Buen dia

                                        Existe un complemento que utilizo para la cambiar textos en mayuscula a Mayuscula en la primera letra y minuscula, como en Word,
                                        Favor tener en cuenta
                                        Al consolidar varias hojas, por ejemplo de estado financiero de cada mes, cada mes tiene una dos o tres cuentas nuevas. Al consolidar no me presenta las cuentas adicionadas ni el texto de las cuentas solo el codigo

                                        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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Co-editing like Google Sheets(color marker) who is working on which cell/row

                                          It would be nice to see if Office 365 could be able to also in the desktop client co-edit within Excel, so you could see who was working and where they set their marker. Just like the color here is blue when I mark this cell I am active working in. Have you guys thought of that, and if yes, are you going to publish that to fasttrack?

                                          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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4
                                          • Don't see your idea?

                                          Feedback and Knowledge Base