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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Support Office themes in VBA editor

    Also, add an option to make the theme match the current theme of the Office so that if we change the Office theme to Black the VBA theme will change automatically to match this theme.

    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 →
  2. configurable hotkey to break excecution of a VBA code

    There are many computers with no break key.
    On those computers (laptops) wh NEED a feature to break a code, otherwhise an error can cost a morning of work!!
    Seriously, this is an important one

    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 →
  3. Inputbox: font size make it adjustable in VBA. lot of people need to input text at say 3 meter from the desktop.

    Inputbox: font size make it adjustable in VBA. Lot of people need to input text at say 3 meter from the desktop using a barcode scanner.

    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 →
  4. 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 →
  5. 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 →
  6. How to disable interaction between Excel instances? VBA runs slower as instances increase. Not like that two days ago. what updated?

    Like to see an option to completely isolate each Excel instances for speed, so my 8-core computer can use all the cores. Now 8 instances only run 30% (3.9% /instance). Shame.

    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 →
  7. 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 →
  8. How about removing all the none essential junk like BING MAPS and PEOPLE GRAPHS ?

    PLEASE make it possible to remove ALL ADD INS including BING MAPS (completely useless) and PEOPLE GRAPHS (even more useless)

    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 →
  9. Fix Excel so XNumbers works

    XNumbers (v6) was a marvelous advanced mathematics add-in for earlier versions of Excel (before 2013). In Excel 2013, it caused Excel to open up empty worksheets, until an update fixed the problem. In Excel 2016, the empty worksheet symptom reappeared, until some further update "fixed" it so it no longer works at all! Why? The error message is unintelligible!

    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 →
  10. 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 →
  11. يرفض برنامج الاكسل تسجيل ميكرو ويصدر رسالة تعذر التسجيل دائما

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

    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 →
  12. 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 →
  13. 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 →
  14. Excel core issue - Slow async UDF

    See https://github.com/Excel-DNA/ExcelDna/issues/232

    We need to use Excel async UDF with 100k+ call per sheet. We have evaluted the Excel behaviour and found out:
    sync UDF: almost constant time (around 2 us) per UDF call
    async UDF: time per UDF call increases about lineary with the number of total UDF uses per sheet

    Is this a bug? Can someone confirm this issue and shedule it for a fix?

    Here are data from our measurements: see https://answers.microsoft.com/en-us/msoffice/forum/msofficeexcel-msoother-mso_2016/excel-core-issue-slow-async-udf/dd9c47a0-02eb-4d69-982e-4bebf9edac6d

    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 →
  15. 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 →
  16. 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 →
  17. Expand/Collapse of code block in VB Editor

    For easier reading and more effective coding, I strongly hope you add a feature of Expand/Collapse of code block in VB Editor.
    読みやすさ、コーディングの効率化のため、VB エディターにコードブロックを展開・縮小する機能を追加してください。

    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 →
  18. 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 →
  19. 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 →
  20. Allow plugins/add-ins to be accessible when a worksheet in excel is protected.

    I have protected the excel sheets from users modifying cells and margins however for plugins/addins like T-BARCODE to generate barcodes in excel the add-in is denied from generting the appropiate barcodes when cells are linked to the program.

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

Feedback and Knowledge Base