Feedback by UserVoice

Feature Requests and Feedback

I suggest you ...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(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. JS API function to prevent user from sheet interaction

    It would be extremely helpful in certain cases to prevent user to interact with the sheet/workbook while some action in the task pane is required or when some process is running (e.g. when some complex sheet changes are being performed - formatting, inserting columns, inserting data, charts....).

    45 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      1 comment  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
    • Add Workbook.CancelEdit or WorkSheet.CancelEdit to get around GeneralExceptionError when cell being edited

      It would be great to have a CancelEdit or have the Range Select / setting range values automatically cancel the editing and avoid this error which seems to have no workaround.

      Whenever a cell is being edited by the user, any attempt to select a different range or update values in different ranges causes the General Exception error. There is no method to Cancel the Edit (essentially just need to send the ESCAPE keystroke to the workbook).

      To reproduced just double-click on a cell to go into edit mode and then execution of this code fails:
      Excel.run(function (ctx) {
      //this…

      47 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        2 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →

        Hi Brian. Thank you for your input, it is greatly appreciated! We’ve added this to our backlog as something we want to implement. There are many items on the backlog, so we can’t set an exact estimated time for this, but we’ll keep you posted with status updates.

        Thanks!
        Office Extensibility Team

      • Allow Officejs to open external excel workbook programatically

        There should be a way to open a external excel workbook by providing URL for that file on excel online via officejs. so that user can open a template stored on some other server which contains desired formatting and named-ranges which can be modified on Excel Online

        51 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          5 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
        • Enable binding keyboard shortcuts to a button in Office Add-in or a function in JavaScript

          I have implemented an Excel Add-in, where there are buttons. Clicking on a button will trigger a JavaScript function.

          It will be much convenient to allow users to bind shortcut to a button / function. Users will be able to trigger them more quickly when they need.

          There may be several possibilities as solutions: 1) provide a mean in JavaScript API to bind a shortcut to a button / function; so it will be the job of the add-in developer to bind a shortcut 2) provide a mean to allow users to bind a shortcut to a button in an…

          19 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            1 comment  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
          • Expose Workbook events via Excel JavaScript API

            Similar to Document.SelectionChanged event, the following Workbook-level events would be useful to have exposed via the JavaScript API (in no particular order):

            Activate,Deactivate
            BeforeSave,AfterSave
            BeforeClose
            Shutdown
            SheetActivate,SheetDeactivate
            SheetBeforeDoubleClick
            SheetBeforeRightClick
            SheetChange
            SheetSelectionChange

            153 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              2 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →

              Thank you for your request!

              We are collecting API requirements for developing Office Add-ins in Excel, specifically for Events API.

              If you are considering moving an existing COM/VSTO/VBA Add-in to Office Add-in, or creating a new Office Add-in in Excel, and have events requirements, please fill the survey below and help us focus on the right set of events and design. We truly appreciate your help!

              https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR-JHDwXr1WhPtbjLQNPOgHtUOFhNTTRVNEE5WE9VVzExOVY5Tko2V05TSi4u

              Thanks!
              Office Extensibility Team

            • Add a method to copy a sheet with all data and formatting because there are no back-up or undo options for add-ins.

              Since there is no way to cancel the changes made by an add-in, we need to provide users with backup options.

              The current version of JavaScript API for Excel doesn't have a method for copying a sheet with its data and formatting, there are no elegant and fast workarounds available.

              Could you please let us know if it's possible to add this method to JavaScript API for Excel?

              114 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                2 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
              • Allow Office Add-in in Excel to configure a cell so that user chooses value from a list of values

                Enhance the Office JavaScript APIs (for Excel 2016+) to expose a mechanism (perhaps a Validation relationship or property) that allows the developer to configure a cell so that the end-user selects the value for the cell by picking from a list of values. The list of values might be specified by some other range. In a VSTO add-in (and native Excel) this can be achieved by configuring the Data Validation properties on a cell/range.

                37 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  3 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
                • Add worksheet activate/deactivate; workbook shutdown events to the Office Add-in Javascript APIs

                  The enhanced Excel-specific APIs available for developing Office Add-ins that run with Excel 2016 are a nice start. There are some key missing APIs. One area in need of extending is eventing. For workbooks that contain multiple worksheets, it is critical for the Add-in to be able to determine when a worksheet is activated/deactivated so that the Add-in's UI can adapt accordingly. Similarly, the Office Add-in should be able to hook an event so that when the workbook gets closed/shut down (and maybe Saved), the Add-in can persist in-memory state into the workbook.

                  33 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    1 comment  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →

                    Thank you for your request!

                    We are collecting API requirements for developing Office Add-ins in Excel, specifically for Events API.

                    If you are considering moving an existing COM/VSTO/VBA Add-in to Office Add-in, or creating a new Office Add-in in Excel, and have events requirements, please fill the survey below and help us focus on the right set of events and design. We truly appreciate your help!

                    https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR-JHDwXr1WhPtbjLQNPOgHtUOFhNTTRVNEE5WE9VVzExOVY5Tko2V05TSi4u

                    Thanks!
                    Office Extensibility Team

                  • Provide more information with the Binding.BindingDataChanged event (for Excel table bindings)

                    The current BindingDataChangedEventArgs object passed to the event handler for the Binding.BindingDataChanged event only contains properties for the binding that raised the event and the type of event. There is no specific information about what cells, columns, or rows in the table object were changed. When dealing with tables with many rows and columns and/or end-user gestures that edit/insert/delete many cells/rows/columns at once, this API is not very useful. Contrast this to the (Excel) COM APIs where, at least, the SheetChanged event provides a Range object that describes what was changed.

                    28 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      2 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →

                      Thank you for your request!

                      We are collecting API requirements for developing Office Add-ins in Excel, specifically for Events API.

                      If you are considering moving an existing COM/VSTO/VBA Add-in to Office Add-in, or creating a new Office Add-in in Excel, and have events requirements, please fill the survey below and help us focus on the right set of events and design. We truly appreciate your help!

                      https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR-JHDwXr1WhPtbjLQNPOgHtUOFhNTTRVNEE5WE9VVzExOVY5Tko2V05TSi4u

                      Thanks!
                      Office Extensibility Team

                    • Add Abitility to create pivot Table via Office Javascript API

                      In the current version of the office javascript api I can see that the setSelectedDataAsync method allow only inserting text, matrix and table into excel spreadsheet.

                      I would like to see the javascript api enhanced and allow inserting pivot Table also. In this way I can use pivot Table helpers (such as slicer, fields list ....) and also refresh pivot table programmatically.

                      70 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        1 comment  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
                      • Provide a feature which enables to create the bindings to named range which has multiple ranges in it

                        Can you please provide a feature which enables to create the bindings to named range which has multiple non contiguous ranges in it ?.

                        9 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          1 comment  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →

                          Thank you for your request!

                          We are collecting API requirements for developing Office Add-ins in Excel, specifically for Events API.

                          If you are considering moving an existing COM/VSTO/VBA Add-in to Office Add-in, or creating a new Office Add-in in Excel, and have events requirements, please fill the survey below and help us focus on the right set of events and design. We truly appreciate your help!

                          https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR-JHDwXr1WhPtbjLQNPOgHtUOFhNTTRVNEE5WE9VVzExOVY5Tko2V05TSi4u

                          Thanks!
                          Office Extensibility Team

                        • Only fire BindingDataChange event when cell data changes

                          Currently it fires on scroll or changing formatting or cell width or a bunch of other random situations. Additionally, it should probably only fire when the user actually changes something, not when I write something with the API

                          16 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            1 comment  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →

                            Thank you for your request!

                            We are collecting API requirements for developing Office Add-ins in Excel, specifically for Events API.

                            If you are considering moving an existing COM/VSTO/VBA Add-in to Office Add-in, or creating a new Office Add-in in Excel, and have events requirements, please fill the survey below and help us focus on the right set of events and design. We truly appreciate your help!

                            https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR-JHDwXr1WhPtbjLQNPOgHtUOFhNTTRVNEE5WE9VVzExOVY5Tko2V05TSi4u

                            Thanks!
                            Office Extensibility Team

                          • Excel Apps - Ability to create Pivots programatically

                            Having the ability to create custom pivots programmatically would be useful feature for reporting latest data for better user experience.

                            24 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
                            • Excel Apps - Enable Data validation support

                              Data Validation support is a key feature requirement for using Office Apps for OLTP systems.
                              The main idea is to fill the gap between VSTO features and Office Apps. This will help in easy portability of VSTO based apps to Office apps.

                              16 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                3 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
                              • Don't see your idea?

                              Feedback and Knowledge Base