Feedback by UserVoice

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. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

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. Please support Unicode font in VBA

    Please support Unicode font in VBA.

    Thank you!

    52 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  2. Update Visual Basic for Applications

    Visual Basic for Applications is still version 7.1 from 2012. It's high time that power user portion of the application received updates to the interface, IntelliSense, and features. That portion of the program needs to be aligned with the current features now available within the Microsoft Suite. It also needs a facelift to the Userforms palette. I suggest starting with Excel, where VBA is most widely used, then PowerPoint, Word, Outlook.

    Don't go destroying developer's programs, just add interoperability, functions, and facelift.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  3. Create a command line tool for signing Office files with a digital certificate

    Besides Office, Excel files can be created using numerous software tools. More often than not, batches of macro-enabled Excel files are processed with scripts for productivity purposes. However, VBA code signing cannot be part of an automated process, as it is a manual task that requires opening & saving the file in Excel.

    This request is about creating a command line tool for signing Office files with a digital certificate, similar to MS SignTool.

    In addition, the existing macro signing process in Office is not 100% compatible with Open XML specifications. I can clarify this statement in a private discussion…

    81 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    22 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  4. Spell out Number with Currency

    Can excel have an add-in that spell-out number from figure and selection of currency name like sample
    123 - One Hundred Twenty Three
    $123 - One Hundred Twenty Three Dollar
    $123.01 - One Hundred Twenty Three Dollar and 1/100
    P32.09 - Thrirty Two Pesos and 9/100

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  5. Inventory data sheet

    I want to multiply data in column c by data in column d and have the formulas decend down the table without having to type in the formula in each cell
    so I can create an inventory sheet

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  6. Enable Macabacus Productivity Add-in Compatibility - Home & Office 2019

    Macabacus is a productivity suite that really cuts down on my work time because they allow you to cycle through precedents within a formula (by using arrow keys) so that whenever you click on a precedent cell within the formula, you can choose to be taken to that reference cell automatically (any tab throughout the workbook) and continue auditing the formulas in the precedent cells.

    However, I've spent hours trying to incorporate this Add-in into Excel, but I think there may be some sort of issue with the 2019 Excel Release. I'm an advanced user and just purchased Excel 2019…

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  7. Add predictions(data science) for selected data

    Add predictions(data science) for selected data. Like wind speed(wind farm) prediction using existing numerical data.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  8. More vba events

    VBA events are extremely powerful but currently they are seriously lacking! If the Excel team went through and exposed more events VBA would a lot easier to manage for complex applications.

    Events to expose:
    * Row and column insertion
    * Table specific events:
    ** Table - Insert_Row
    ** Table - Insert_Column
    ** Table - Cell_Change
    ** Table - On Filter
    ** Table - On Filter button click
    * Chart events!
    ** Chart - On Mouse Down
    ** Chart - On chart object select
    ** Chart - On chart resize
    * Shape events
    ** On shape resize
    ** On shape click …

    13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  9. Content Pane Remove Size Limit, Add Positioning, Resizing

    There is a limitation to the width and height of a Content Pane at 1000 x 1000px. This limit is imposed when resizing via mouse in Excel Desktop and the JavaScript API. This (via mouse) is not true in Excel Online (or in PowerPoint) where the size can be set and saved to any size via mouse.

    It would make the Content Pane consistent and open up a huge number of innovation opportunities to remove the current 1000 x 1000px limitation in the JavaScript API and Desktop Content Panes in Excel.

    The ability to position and resize the Content Pane…

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  10. Correct illogical limit of 255 characters for entering Matrix formulas using VBA

    When you use Excel, you have a limit of 8192 for the lenght of a formula.

    When you assign a matrix formula using VBA, it is restricted to 255.
    Even using macro recorder, it'll save the correct instruction, but then it'll be useless as VBA won't execute that instruction.

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  11. Be able to use SQL directly on Excel Tables

    Excel Tables are great, but they would be super is you could use SQL on them directly (like a range or worksheet). Select, Join, Insert, etc.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  12. add to the ribbon a nummeric up-down control

    Not only to excel but to all of office
    implement getmin, getmax, getvalue

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  13. يرفض برنامج الاكسل تسجيل ميكرو ويصدر رسالة تعذر التسجيل دائما

    يرفض برنامج الاكسل تسجيل ميكرو ويصدر رسالة تعذر التسجيل دائما

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  14. ERROR in VBA "Select Case" documentation.

    The documentation for the "Select Case" statement is not current.

    There is a reference in it to using "Like" or "Is" as part of the "Case" statement.

    It does NOT work in VBA now. Apparently these tow words have been deleted and the compiler now figures it out itself.

    But what a problem when I tried to use it and just got a compile error which specified some rules having to do with logical statements but nothing suggesting that "Is" or "Like" are not compiled now.

    What a wast of peoples time to read the documentation and then find that…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  15. Save worksheet as pdf macro

    So I just had a long chat (more than 2 hours) with the Microsoft contact support desk and I even shared my screen with them. It was about creating a button in Excel so when i click on it, it saves the worksheet as a .pdf file. Well, the contact person tried everything, every possible code she knew, and it did not work.....HINT: Make it easier for non-coders! Also for other macro functions, like wiping out data without clearing the formula

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  16. Sandbox for Macros

    The security for macros should be extended as new attacks arise. For example it should be possible to define some Sandbox for Macros, limiting their permissions: No file access, network access, etc
    Maybe it is possible to explicity ask the user if a macro tries to do one of these things

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add precedents & dependents to JavaScript API.

    Please add functionality to future versions of the JavaScript API to trace precedents and dependents of cells, as per the features in VBA.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  18. 25 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  19. Office2013以前に作成したVBAをOffice2016以降で編集しなおすとOffice2013でコンパイルエラーになる

    この現象はExcelのVBAでもAccessのVBAでも発生する現象です。

    新しいPCをOffice2016 Proffesional Plusにしました。Excel2013以前に作成したVBAをExcel2016で修正して、Excel2016で実行すると問題なく実行できるが、Excel2016で修正したものをExcel2013以前で実行すると、VBAの中のDate関数やLeft関数などでコンパイルエラーが発生する。

    原因はExcel2016のVBAではMicrosoft Office 16.0 Object Libraryが参照設定されてる。Excel2016でVBAを修正すると、この参照設定が保存される。この参照設定が保存されると、Excel2013以前でVBAを実行すると、Excel2013ではMicrosoft Office 16.0 Object Libraryが参照不可になり、しかもMicrosoft Office 15.0 Object Libraryの参照設定が外れてしまうため、Excel2013で実行時にコンパイルエラーが発生する。この現象は、Excel2013のVBAで参照不可になっているMicrosoft Office 16.0 Object Libraryを外して、Microsoft Office 15.0 Object Libraryの参照設定すると回避できる。

    Accessも全く一緒で、VBAの関数やファイルダイアログやファイルシステムオブジェクトなどでコンパイルエラーが発生する。エラー回避するにはOffice2013のVBAで参照設定をやり直すしかないが、ランタイム版の場合は修正することができない。Office2016以降のVBAの参照設定にはMicrosoft Office 15.0 Object Libraryが見つからないのでどうすることもできない。

    何台かで試したのですが、Office2013でもコンパイルエラーがでないPCもありました。Office2013(それ以前のバージョンも含む)のVBEの参照設定で、Microsoft Office 16.0 Object Libraryが自バージョンに置き換えられるものと置き換えられないものがあります(理由は不明)。置き換えられないものが参照不可となり、コンパイルエラーが発生します。

    ただ参照不可となったPCでも、参照設定を1度行うとコンパイルエラーはなくなります。

    私の環境で確認できるのはここまでで、参照設定を行うと逆にコンパイルエラーを再現させることができなくなります。今回のような現象は、OSやOffice2013の環境を何度もクリーンインストールができる環境であれば再現テストができると思います。この現象の厄介なところは一度回避をしてしまうと再現ができなくなり、以降の調査が難しくなります。

    とりあえずの対処は、Office2016で作業したものを、現象を回避したOffice2013で保存し直したものを使うことにします。

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  20. Macros: Make it easy to WRITE * SAVE * SHARE * ADD to other Devices

    Macros: #1 - provide better step by step instructions #2 - let me SAVE my macro to the Ribbon to apply with any spreadsheet #3 - let me easily add an ICON like I do for my desktop shortcuts, #4 - Let me share my macro with a friend #5 - Let me make it available to ALL of my devices - desktop, laptop, tablet, phone. Macros should not be difficult and they currently are !!!

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3 4 5 15 16
  • Don't see your idea?

Feedback and Knowledge Base