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. Money in Excel: track investment portfolios (holdings, transactions) across brokerage accounts

    Tried Money in Excel today with a new subscription to MS 365. It seems to show only the total account balance but does not download holdings and investment transactions at this time.

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    Thank you for using Money in Excel.

    Since you mentioned that the template doesn’t show investment transactions, kindly confirm which financial institution are you using with Money in Excel so that we can review the issue.

    Best,

    Vipin Nair
    The Microsoft Team

  2. Fix the black and grey boxes that cover the screen when you scroll

    Whenever I scroll too fast in Excel on my PC black and grey boxes appear everywhere and cover what I am working on. This is incredibly frustrating because there is no way to get rid of the boxes.

    This only happens on my external display and it only happens in Excel.

    Please fix this issue.

    https://superuser.com/questions/1053006/excel-grey-and-black-boxes-on-secondary-display

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

    We’ll send you updates on this idea

    96 comments  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →

    Hey folks,

    I am not seeing new recent activity in this space. It is possible you are seeing this less due to our on-going performance investments including in speeding up our grid rendering. Details on latest speedups are at https://aka.ms/excel-perf-improvements.

    That said, if you still are experiencing this please provide specifics on your configuration and monitors… better still please send feedback about the problem from within Excel (go to Help > Feedback), which will include some diagnostics to aid our investigation.

    thanx,
    Prash
    [MSFT]

  3. Quit having a spreadsheet reopen in a different size than it was when it was closed

    When I close a spreadsheet, it is the size I want it to be. But when I reopen it, Excel is as likely as not to have "decided" that it knows better than I do what I want, and it reopens in a different size. Sorry, but I do know better than Excel does what I want, and resent the arrogance displayed in changing my preferences. Make it stop!!!

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

    We’ll send you updates on this idea

    56 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →

    When you say that it opens a different size – can you give more info? Do you mean the application window is a different size (it shouldn’t be) or that the font sizes (zoom) are different? (again, they shouldn’t be)

    Additionally, if you can post a video of what you’re seeing, that would be a big help for us.

    If there is a problem here, it’s definitely something we’d want to fix.

    Cheers,
    Dan [MS]

  4. Provide IBCS-Charts

    or buy ZebraBI (Add-In) www.zebrabi.com

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

    We’ll send you updates on this idea

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    By IBCS, I assume you are referring to “International Business Communication Standards”. Could you provide more detail on what you are specifically looking for? IBCS is pretty broad.

    Thanks,
    Scott [MSFT]

  5. Add a setting/option where all CSV/delimited files are opened as "Text"

    Add a setting called
    "Open text-delimited files (CSV, etc) as text only, with no type inference."

    When this setting is active, then every column's format will be "Text" when a CSV or other such file is opened, so that the initial view is exactly the text represented in the CSV.

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

    We’ll send you updates on this idea

    31 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    info needed  ·  Yigal Edery responded

    Thanks for the feedback!

    Can you comment on whether you expect this to basically import all the lines as text to column A, or if you have some other expectation?

    Also, I’m assuming people refer here to the file/open path, and not to the Data/From-Text or New-Query/From-Text path.

  6. Allow the pivottable to not aggregate data (e.g. show values)

    I need to create a matrix in Excel that doesn't aggregate (e.g. Sum/Count) values. The question of how to do this has been asked dozens of times online over the last couple of years, but still there is no solution. Can Excel therefore produce a plain matrix, or allow pivottables to output plain (unmodified) values from the data field list?

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

    We’ll send you updates on this idea

    info needed  ·  33 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  7. Increase number of series from 255 to atleast 1000

    For technical or scientific data (eg band structures) we need many data series charted before narrowing down to fewer. The series limit is very annoying and has no fix except to go to open source or a different app.

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

    We’ll send you updates on this idea

    2 comments  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    Could you provide some additional examples or use cases where you need more than 255 series? We want to better understand the scenarios of usage.

    Thanks,
    Scott [MSFT]

  8. unstable

    Excel freezes; unstable can't handle large number of large files. New features are great but would rather have more stable product

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

    We’ll send you updates on this idea

    info needed  ·  2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. my calendar insight

    Make it possible to generate my calendar insight for a group in the "template my calendar insight". For example for a mail group with approval or for a calendar group if it's shared.
    A group insight will be very beneficial in decision making and improving productivity etc.

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Ziyan,

    Can you give a bit more info about how you see this feature being applicable to and working in Excel?

    Thanks,
    Dan [MS]

  10. Build more tools to perform stochastic / probabilistic analysis and Monte Carlo simulation


    1. More inverse cumulative distribution functions (Poisson, Exponential, Negative Binomial, Weibull, etc.);

    2. Ability to confine the distribution between certain values;

    3. Ability to generate / simulate time series;

    4. Ability to sample/simulate all inverse cumulative distribution functions without continuously recalculating the workbook (ex. run the simulation behind the scenes much like the current IRR function operates though iteration);

    5. Ability to correlate distributions;

    6. Ability to run sensitivity analysis on the results;
      It is currently possible to build all of the above functionalities through VBA but having dedicated tools will bring considerable efficiency improvements.

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

    We’ll send you updates on this idea

    5 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for logging this, Lyubomir. How do you do these today? Is deeper integration with R potentially useful for such scenarios, at least for the analysis?

  11. add Microsoft Access query and SQL tools

    Add Microsoft Access type Query and SQL tools, allowing easier criteria entry, sorting, creation of calculated fields, and even linking together tables sharing a common key.

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

    We’ll send you updates on this idea

    info needed  ·  3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. UNIVERSAL SHEETS AND WORKBOOKS MANAGER

    It is necessary to add A UNIVERSAL SHEETS AND WORKBOOKS MANAGER similar to file manager for OS. Plus different small features as toggling, vertical tabs and so on.

    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  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  13. 4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →

    What type of deeper integration for charting are you looking for? Currently, most of the UI is shared and they use the same charting engine.

    Thanks,
    Scott [MSFT]

  • Don't see your idea?

Feedback and Knowledge Base