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. Add an Automatic Open, Refresh, Save and close feature instead of having to go through batch files and power shell

    Add an Automatic Open, Refresh, Save and close feature instead of having to go through batch files and power shell

    It could be a Automation button that Schedules a Refresh of all the Data and Macros in an excel sheet then closes it

    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. Providing 64-bit version of MSDAORA driver

    A strategic customer is facing a compatibility issue in using their LOB excel Macro after upgrading from Windows 7 and Office 2010 32-bit to Windows 10 1709 and Office 2016 64-bit.
    The macro is unable to connect to an Oracle database as there is no available 64-bit MSDAORA driver

    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 →
  3. Excel 365, home; windows 10 pro x64 - In EXCEL 365 VBA code, the statement "Application.ScreenUpdating = False" fail to operate in some VBA

    In EXCEL 365 VBA code, the statement "Application.ScreenUpdating = False" fail to operate in some VBA subroutines and macros. With "Application.ScreenUpdating = True" the execution is dramaticaly slowed down. Please help.

    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. start using C# as the macro language instead of visual basic

    well, visual basic great language loves it but Microsoft seems to have abandoned the language. C# is clearly the new emphasis so, therefore, start the move to make C# the default language for the office products. plus there is an opportunity to increase the performance and features of the macro language. allowing for the creation of exportable modules and even binary macros that run faster or can be more easily exported to different machine

    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 →
  5. Incorrect formula for standardized residual in the regression data analysis tool

    Currently, the standardized residual in the regression data analysis tool is calculated as the residual divided by the standard deviation of the residuals.
    This is incorrect.
    Notwithstanding the fact that the correct standardized residual should account for leverage (this is actually called a studentized residual in some schools of thought), you should at least modify the formula for standardized residual so that it divides the residual by the standard error of the estimate, which is also called RMSE, instead.
    The difference is that the standard deviation of the residuals is calculated as:
    SQRT(SSE/n-1)
    Whereas, the standard error of the estimate…

    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 →
  6. Office Scripts for Excel Desktop

    Hi Excel-Team,
    on Ignite and on the Excel Tech Community blog, you have announced Office Scripts - including a macro recorder for Excel JS.
    That's really awesome and I am looking forward to the preview at the end of this year. However, Office Scripts will (is) currently only available for Excel on Web.
    I would like to suggest to add this feature to Excel Desktop too in the (near) future.
    This, as on one hand not all files are stored/used in the web and Excel for Web has less features than Excel for Desktop and on another hand, I guess,…

    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 →
  7. Improve VBA protection

    it is not a secret that the VBA protection password is very weak, it is very frustrating that I can't defend properly a sensitive code in the one of the biggest and popular software (Excel) in the world.
    improving VBA protection is a game changer for lots of people.

    5 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. excel macros

    When the user uses the remote desk of the laptop(the system of the laptop is windows 10 1903 rdp) to connect to another computer, the excel document with Macros cannot open or save(the version of the office365 is latest).

    9 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 →
  9. VBA doesn't check the maximum text line length when importing a module

    VBA doesn't check the maximum length of every text line when importing a module (.bas file). This can cause an issue when saving the VBA project inside VBA when the text line of the .bas file is higher then allowed, which can lead at the end to a full crash of Excel. This is a major issue.

    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 →
  10. Followhyperlink event to trigger with Hyperlink() function

    Have the Hyperlink function trigger the followhyperlink event.

    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 →
  11. VBA histogram bin

    Please make the number of bins and bin width for histograms open to VBA. I can read the values, but I can't change them. I want to create a macro that allows me to use a spinner so I can adjust the number of bins or the bin width.

    I am working with statistics and need to be able to quickly adjust these numbers for students.

    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. Disabeling Calculate; norma, page layout & page break Preview on task bar at the bottom.

    I suggest Disabling Calculate; normal, page layout & page break Preview on task bar at the bottom. Allow the user to make any of the options, their default view, but only for the active workbook.

    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. Analysis ToolPak's Regression tool should not use the clipboard

    After you run the Analysis ToolPak's Regression tool, you can paste some of the numbers that appear in the output. There is no warning that the Analysis ToolPak will use/clear the clipboard. Users may have had important stuff on the clipboard. It is also bad practice to use the clipboard as part of a macro. Please change the Regression tool so that it does not use the clipboard.

    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. AutoFit columns in the output sheet of the Analysis ToolPak's Regression tool

    Currently, many cells in the output sheet of the Analysis ToolPak's Regression tool are cut off by default because the columns are left at their default width. Please AutoFit the columns as part of the generation of the output. Also, select cell A1 by default so that the output sheet looks cleaner.

    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. Eliminate double spaces from the titles of the graphs generated by the Analysis ToolPak's Regression tool

    The residual plots use 2 spaces before "Residual Plot" and the line fit plots use 2 spaces between "Line Fit" and "Plot". Please change these to be a single space.

    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. Non-overlapping arrangement of graphs generated by the Analysis ToolPak's Regression tool

    Currently, the graphs generated by the Analysis ToolPak's Regression tool are cascaded (i.e. the next graph overlaps most of the previous graph, but offset a little). This arrangement is useless since you can only see the last graph, and you must spend time to move the graphs out of each other's way.

    Please arrange the graphs in a grid by default. There should be a row/column of Residual Plots and a row/column of Line Fit Plots right next to it. The Normal Probability Plot will have to reside outside of the grid. Luckily, there is a nice space for it…

    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. Provide search boxes on every VBA Help page!!

    Provide search boxes on every VBA Help page!!

    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. VBA Developer should highlight paired parentheses

    While editing VBA code within the Developer window, there should be some basic syntax highlighting such as paired parentheses. This would help while coding complex nested conditions.

    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 →
  19. "Block macros from running in Office files from the Internet" causing operational issues.

    "User Configuration > Administrative Templates > MS Excel 2016 > Excel Options > Security > Trust Center > Block macros from running in Office files from the Internet" is causing operational issues for the org I work for.

    Probably it should not be in Microsoft security baseline until it works as expected.
    It blocks macros for files that are opened from Trusted or Intranet sites. Another interesting finding is that it seems like this GPO will block macros in files saved and launched from INetCache folder, the folder where IE11 stores temp Internet files. Trusted or Intranet sites can store…

    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. Lock some cells in all sheets

    Hello
    I want to lock some cells in all the sheets at once. Please guide. Thanks

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

Feedback and Knowledge Base