Feedback by UserVoice

Feature Requests and Feedback

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

    83 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 →
  2. Pivot Tables should support DataSet measures from PowerBI

    Currently, when using Analyze in Excel OR Connect to Data with a dataset in PBI, simple measures created in datasets are not allowed in pivot tables "values". This causes a developer to re-create manually each measure or model each report with explicit sum/avg/etc and hide numeric fields modeled with aggregation which are also called measures. Excel should support these measures in Values in a Pivot Table to reduce complexity in modeling, unleash the power of a dataset for self service and provide a very easy option for storing data in one place where it is usable by both excel and…

    24 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 →
  3. Excel-JS should support already open Excel workbooks

    When multiple workbooks are open Excel treats their worksheets in a similar way across all open workbooks: you just qualify range references with the workbook name.
    Excel-JS should behave the same way when the user opens multiple workbooks.

    5 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. 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 →
  5. Excel-JS and VBA: scan VBA project to identify all unique object model calls.

    When designing and developing a VBA the developer can be reasonably sure that all the Excel APIs that are required for the project are available.
    If the developer wants to convert an existing VBA project to Excel-JS there is currently no easy way to find out if the VBA APIs being used exist in the restricted subset of Excel-JS APIs.

    It would be extremely useful to have a tool that analysed a VBA project and produced a unique list of all the VBA OM calls.

    1 vote
    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 →
  6. Ability to get username in Excel

    I'd like to be able to access the username listed under Account -> User Information in my add-in in Microsoft Office Excel 2016.

    Besides being able to customize the add-in experience and address the user by first name, having the full name would allow me to look up internal users and perform more advance functions like looking up permissions or recording their userId along with actions they perform.

    33 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 →
  7. Keep add-in alive when user closes task pane

    When the user closes the web add-in task pane, the web add-in is terminated for that workbook with no warning. I currently see at least four distinct issues:
    - any in-progress operation may be interrupted with unpredictable results
    - The add-in’s Excel event processing and handling is terminated. So, there is no longer any reaction to user gestures such as editing a cell or changing the selection
    - The user steps needed to re-open the task pane (to re-attach the add-in really) are non-obvious for the average user
    - If the user does discover how to re-insert the add-in, the…

    1 vote
    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 →
  8. chart.getData() Method

    Add a getData() method to the chart object to get the worksheet range sourceData and seriesBy information of a chart.

    43 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. Header and Footer in Excel Workbook

    Similar to insertHeader in Word, can we have a similar function to read/update Header/Footer in Excel.

    4 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 →
  10. Please .... Add the count cell by color function to Excel...

    HI
    why we cant use count or sum cells by background color as a directly function in Excel.
    It mean Microsoft development team can't resolve it.
    why we most write some codes in vb6 module for this???
    why we can't use it directly in Excel formulas???

    best regards

    6 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. Bug: Error 429: You do not have an appropriate license to use this functionality

    Hi, I reported the following to Microsoft Customer Service and Support and the pointed me to this site to report this bug.

    We have developed applications in Visual Basic 6, which are executed as COM Addin from Microsoft Excel.
    Customers who use the Office 365 Insider program suddenly received the following notification when using our application:

    Error 429: You do not have an appropriate license to use this functionality

    Research provided that this message is generated by customers who currently have Excel version 16.0.8326.2052.
    This version is currently distributed through the Office 365 Insider program, also with Office 365 business…

    7 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 →
  12. sum by color

    Would be great if there will be some function, which would be able to make sum/average/count by cell color in Excel. This is very common question from my students and the solution in VBA is too difficult for them. It would be sufficient if there will be color code as text available and then we could just sum etc. by the code.

    3 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 →
  13. Add the print api

    I generate tables for the corresponding styles based on the data in the sheet. I want to print them out.

    I tried to find the api in the document,but I did not find it.

    26 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 →
  14. 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 →
  15. Ability to open/replace workbook with Excel JS API in a similar way Word API can with insertFileFromBase64

    We have a requirement to load a workbook from a remote source from within the add-in. User logs in, selects from a list and workbook template loads.

    With the Word JS API we can load a template remotely using an AJAX call that returns the workbook as a base64 string and then insert the response into the current workbook using the replace option. AFAIK this doesn't exist for the Excel API and we download the workbook and then instruct the user to open from the download pane.

    161 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    21 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →

    The API is in preview for Excel Desktop and Mac now!
    This feature is not be able to GA due to this API is not available on Excel online due to the Excel online cannot insert worksheet from the external workbook, so Team is now working on investigating on Excel online. and figure out the features that we can support now and our strategy is to build addFromBase64 for Excel Online with a limited supported feature, which allow us to GA this API. and then we will continue iterating this API to support more features

    For Excel Desktop and Mac beta preview. you could use our Beta CDN, more info on this here https://aka.ms/excelapiopenspec

    Here is a sample code snippet using the API

    https://gist.github.com/jipyua/caec8eb5fddc0f611c43a1dbb356fa2a

    key line of code context.workbook.worksheets.addFromBase64(mybase64)

    send an xlsx (base64 encoded)

    please use it and send us feedback!

  16. 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
    68 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 →

    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

  17. Text to Column

    Inside Office.js in Excel 2016 I'd like to be able to call Excel's text to column function from javascript.

    According to StackOverflow.com, it appears this feature does not exist yet: https://stackoverflow.com/questions/45448813/office-js-excel-call-text-to-column-excel-function-from-javascript/45466949#45466949

    4 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 →
  18. Implementation of print option to a popup dialogue window.

    window.print() does not work to print contents of either a dialogue window or taskpane.

    4 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. Are you here??? I’m Tiffany McDaniel Foster from Craigslist w4m Post. Are you free today? Write back me: tmcdaniel609@gmail.com

    Are you here???
    I’m Tiffany McDaniel Foster from Craigslist w4m Post.
    Are you free today?
    Write back me: tmcdaniel609@gmail.com

    4 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 →
  20. 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 →
  • Don't see your idea?

Feedback and Knowledge Base