Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Provide way in VBA to know who, if anyone, is currently coauthoring a OneDrive/Office365 document

    There are certain functions and events (only tested in Excel .xlsm desktop) that don't work when a document is in coauthor mode using OneDrive/Office365 syncing. If only one person is in the file, the macros work fine. If more than one are in it and co-authoring it would be good to know so certain macros can be prevented from running that otherwise cause the "Reload document" message on the computer that didn't run the macro.
    Some of the VBA that doesn't work during coauthoring include all .FormatConditions code (even though you can manually add conditional formatting, doing it by VBA…

    6 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. Harita Grafiği

    Türkiye Grafiği için Batman-Siirt illeri karışmakta.
    Bolu ile düzce illeri karışmaktadır. Sorunun çözümü halinde daha aktif olarak kullanılabileceklerdir.

    24 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 →
  3. Ability to programmatic update the Excel Add-in cache or other automation way

    Our Add-in deals dynamic server address so we need to update the manifest frequently. The only way to update the Add-in cache is to refresh and insert again, is it possible to do it in automation?

    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 →
  4. Grafiklerin Geliştirilmesi

    Excelde oluşturulan dağılım grafiğinde dikey ve yatay çizgiler oluşturulamamakta.
    Ayrıca yine aynı grafik türünde nokta ismine etiketin isimlendirilememesi hatası mevcuttur.
    Powerbi de bu sorun yok ancak excelde mevcut.

    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 →
  5. Expose the commenting feature via excel-js api.

    Can you expose the comments/notes feature in the excel-js api. I am interested in developing an add-in that depends on comments/notes. I noticed that there are other developers who are also interested in add-ins that need access to comments/notes. Following is a stackoverflow thread about it:

    https://stackoverflow.com/questions/44019257/excel-javascript-api-set-note-to-cell

    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 →
  6. Make a tool for debugging Javascript API in Chrome Devtools

    Debugging on Mac is a pain.. The built-in safari tools are buggy and laggy. The only useful feature of volron.js is displaying console.log's.
    I want a normal developer experience on Mac!

    21 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. track changes in excel

    I work for a large company. We receive requests for proposals in Excel and need to respond in Excel. We need to be able to track our editor's changes in Excel. Currently we can only track changes in Word but that is not the format that consultants use. We have to copy from Excel to Word for editing, then back to Excel to finalized. This is wasting a lot of time. Please add track changes to Excel so that it works the same as Word.

    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 →
  8. Insert picture/shape in Excel range

    Like inserting shapes in a worksheet it would be useful to insert pictures in a range/cell. The range/cell acts as an anchor.

    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 →
  9. Allow Javascript to be used, and shipped, within the excel sheet and not only as an add-in (as VBA is)

    The beauty of VBA is that it ships with the sheet and does not require the installation of additional programs.
    The need to use an add-in means the majority of excel users (accountants, engineers etc.) are unable to write their own scripts without needing an IT department to approve, install and distribute the add-in. In most corporations this means the JS API is just not an option.
    Our only options then become to learn VBA while its on the way out or use Google sheets which lets you do it all online (ie no installation/IT department required).
    Ultimate goal =…

    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 →
  10. Allow Taskpane Addin's and custom functions to control content addins

    This would allow the ability to have the menu system outside of the content add-in. In addition would provide the ability to seamlessly bring in other charting libraries for more complicated live charting of financial data.

    8 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. Ability to inject data in to native PivotTable object

    Currently, you can use the PivotTable object and it's associated collections to create, edit, delete PivotTables. But currently, this relies on using Excel itself for the aggregation.

    It would be nice to instead be able to manually manipulate the PivotTable object and define hooks for expanding Hierarchies to perform custom aggregation.

    This would be useful for using analysis servers which aren't 100% XMLA compliant as well as any other services that want to perform some kind of aggregation on data not available in the worksheet.

    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 →
  12. 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 →
  13. Add TTM Dividend Yield (Trailing Twelve Month) in Data Types for Stocks

    The new Convert to Stocks under Data/Data Types has been extremely helpful. One metric I would like to have added to the Field list is Trailing Twelve Month (TTM) Dividend Yield. This is a common metric in investments, one that I would think your data source already has available.

    3 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 →
  14. Microsoft Excel address correction/verification function using Bing

    Microsoft Excel address correction/verification function/Add-in using Bing

    On Google sheets, users can use Google Maps services to correct/verify address data even at street level.

    Can we have something similar in Excel since we have everything we need to make this work? In Excel, I came across some work around utilizing scripting but why users need to know scripting language for what can be made available right out of the box?

    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 →
  15. implement a row filter

    sometimes it is necessary to view only columns in which specific values appear (without transpose!) it will be a useful feature which will enhance use capabilities

    3 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 →
  16. Delete Duplicate Rows of Data on Excel

    A feature that we can tell Excel to highlight the rows or columns of data that repeat or that are duplicates and DELETE those row or columns of data. I have a company report that prints our company name and subcontractor's name on every project and I only need it shown once. Right now I am having to go in and highlight every row and delete them one-by-one. Time consuming! If there is another way, please let me know.

    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 →
  17. Disable AutoSave in OfficeOnline (maybe at least per API for JS AddIns)

    I currently tested usage of a large amount (20,000 to 100,000) of custom functions provided by an Office JS Excel add in. One very interesting finding was, that as long as it works, Excel online is even faster than Excel's desktop versions (32Bit & 64Bit) for Windows.

    But there is the problem that at a certain amount of functions Excel online isn't able to get it done at all. It stops working and shows an Server not available error. Since it shows "saving..." even when still working while executing the functions, it seems to me, that in this cases the…

    3 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. 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 →
  19. Implement reliable WebSockets for Custom Function Add-In in Office.js.

    Currently the web socket implementation for desktop version of Excel (Version 16.0.11601.20130 32 Bit) is not correct. The property bufferedAmount is not implemented in this version. Further messages are lost, if “send” on the WebSocket is called frequently directly from a custom function. It seems as if the SDXPlatformBundle_foundation.js has some bugs.
    In office online the problem does not exist. Please make desktop version behave like online version of Excel with a complete implementation of WebSockets.

    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 →
  20. Important! Problem with RangeAreas method

    This both code will work in VBA:
    dim rng as range
    set rng = range("d3:d4,f3:f4") // 2 areas range
    rng.copy destination:=sheet.range("...")
    or: reverse region area
    set rng = range("f3:f4,d3:d4") // 2 areas range
    rng.copy destination:=sheet.range("...")
    --------------------------------------------
    There is a rearrangement of the selection so
    It will affect the recording of range.value
    In API-javascript this code did not work
    sheet.getRange("d1").copyFrom("f3:f4,d3:d4");
    because selections do not arrange themselves
    -------------------------------------------------------
    so if using the Findall method: var searchrange=sheet.findAll(...)
    i canot using searchrange nomarly. because the search result order returns a messy result
    I can only format this.
    //
    This is my personal opinion
    Thanks!

    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 →
← Previous 1 3 4 5 9 10
  • Don't see your idea?

Feedback and Knowledge Base