Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add support for Document.getFileAsync method in Volume licensed versions of Office Excel

    I am attempting to use the Document.getFileAsync method in Office Excel 2016 on Windows. Executing the method fails with an "Permission Denied" error.

    Error code: 7000
    Error name: "Permission Denied"
    Error message: "You don't have sufficient permissions for this action."

    This functionality is critical to our Add-in and we have many customers that use this 2016 volume licensed version of Office. They are not able to upgrade since the version is locked down at 16.0.4266.1001.

    22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  2. Page Setup API

    I would like to be able to access the page layout properties of the document so that I can set the print area.

    22 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  3. Support Custom Functions on iPad

    My add-in's core value proposition lies in custom functions and we'd like to support as many platforms as possible.

    Would be great to see custom functions capabilities coming to iPad alongside Web / Mac / Windows!

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add ability to refresh Power Query from Javascript

    Possible scenario: Some tables, pivots, charts connected with Power Queries to Web Service. Bing Maps in Task Pane App. We need to refresh Power Queries when user clicks on a marker/location. Now it is not possible to refresh Power Query from Javascript API.
    Please, add ability to trigger Power Query refresh from Javascript. And will be easier if we could send parameters direct to Power Query (as function parameters).

    20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  5. Deprecate localisation of Excel function names

    Many ages ago someone in the USA got the GREAT idea to localize the names of Excel functions. She probably wanted to please international users from all over the world: why a user from Czechoslovakia should learn a new term "SUM"when he knows "SUMA" from school... And why the foreigner should learn "VALUE" when he knows "HODNOTA" in his language. Well so far so good. But the Czech guy says and writes word "text" exactly the same as his English colleague. God knows why she (the MS person in America) suddenly translated the function "TEXT" as "HODNOTA.NA.TEXT" in the Czech…

    20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  6. Fix the "Invalid API call in the current context." error that's generated if the user has a cell in edit mode when you call ctx.sync()

    I have developed an office.js task pane app that binds to many cells, each linked to variables in mathematical models running on an external server. One of the most difficult errors to mitigate occurs when the user is entering data into a cell while updates come in requiring the app to call ctx.sync(). This generates an "Invalid API call in the current context." error that I currently try to mitigate by calling the hideous function below everywhere one would use ctx.sync. This appears to be an important Excel mode that the API is not designed to handle.

    function ksync(ctx, retryfn,
    20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  7. Enable Access to Excel/VBA Hierarchy in Visual Studio Mac

    Enable Visual Studio Mac to use the VBA hierarchy.
    This will enable VB.Net to automate Excel Mac.
    This will provide a relatively painless, powerful migration path for VBA devs.

    20 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  8. use an array to format font color/weight

    Use a method like numberFormat that takes a table to format the font colors, weights ... of the data in a table.

    For Example :

    const sheet = context.workbook.worksheets.getItem("Sample");
    const formats = [

                ["red", "red"],
    
    ["red", "red"],
    ["red", "red"]
    ];

    const range = sheet.getRange("D3:E5");
    range.XXX = formats;

    18 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  9. Application.ScreenUpdating

    Add possibilities to disable screen updating to speed up things (Application.ScreenUpdating)

    18 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  10. Reverse VLookUp/ WLookUp

    The LookUp formulas are very powerful tools for any kind of application. Often you are not only searching for the first corresponding value in an Excel sheet, but also for the last corresponding value in an Excel sheet. So reverse references would be very useful.
    The Reverse VLookUp should therefore search from bottom to top in the matrix.
    The Reverse WLookUp should therefore search from right to left in the matrix.

    18 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  11. Adding SubTotal method on Range Object

    As in VBA : for example :

    Range("D2:E8").Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(2), _
    
    Replace:=True, PageBreaks:=False, SummaryBelowData:=True

    17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  12. Grouping Ungrouping rows and columns

    Be able to control Grouping Ungrouping rows and columns like it's possible in VBA

    Here vba example

    Sub GroupUgroup()
    'Group row 4 -8
    Application.Rows("4:8").Group
    'Hide groups
    ActiveSheet.Outline.ShowLevels RowLevels:=1
    'Show groups
    ActiveSheet.Outline.ShowLevels RowLevels:=2

    Application.Rows("10:12").Ungroup
    End Sub

    17 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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
    (thinking…)
    Sign in with: Facebook Google
    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

  14. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  15. Automate Task Pane Insertion into Excel

    Excel Addin
    I want to insert the task Pane Addin into my excel file using Powershell script.
    We deploy add-in in SharePoint catalog and then manually insert into excel files.
    This is preventing use from getting into automated deployment.

    16 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  16. 16 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  17. Remove the size limitation of content-pane add-in's in Excel

    In Excel desktop there is a limitation to the width a content pane can be resized when adjusting with the mouse. It appears to be approx 1000px. However, if the columns underneath the content pane are resized, the pane follows this adjustment and will become wider than the 1000px limitation imposed by mouse resize. However, if the content pane is then again resized with the mouse the width limitation kicks in again and the pane width snaps back.

    In PowerPoint there is no such limitation to the width of a content pane Add-In. It would be helpful, and consistent, to…

    15 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  18. 15 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  19. Expose API to allow adding gradients to cells

    I am porting an add-in to Office 365. I see that gradients are not currently supported. The gradients are a key part of the functionality of our add-in (recently demoed to a number of MS execs, including Satya, Brad Smith, Rajesh Jha, and even BillG at MSR TechFest). It would be great to be able to do this soon.

    13 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  20. Office Javascript API Function to Execute Macros that Exist in Workbook

    We just need a clean way to use the Javascript API to tell Excel to execute an existing VBA Macro. While VBA may be falling out of favor to development teams, it's very much alive in the workplace. Excel and Macros are tied to the hip. I imagine this to be a very simple implementation. Let this be an olive branch between VBA and Office JS API.

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base