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. Create unique object names by worksheet

    Charts and other drawing objects don't have unique names. To illustrate, we could have a dozen charts on a worksheet, all named "MyChart".

    These duplicate names make it difficult for VBA and any other programs to work with drawing objects, including charts.

    Excel should enforce unique object names by worksheet.

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  2. Correct status bar calculation

    Status bar calculates according to formatted numbers in cell. So, if there is a number format :

    ##0.00;[Red]# ##0

    and you enter -2
    the sum in status bar will be : 2

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

    We’ll send you updates on this idea

    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  3. 7.8 MB Workbook takes 100 secs to open

    I'm running:
    HW
    Lenovo T550, 16 GB Mem, 500 GB SSD
    Intel Core i5-5300U CPU @ 2.30-2.90 GHz
    Dual Core + HyperThreading ==> 4 CPUs
    No a numbercruncher but not too bad either...

    SW
    Win10 x64 (upgraded from Win8.1)
    Excel 2016 (32-bit) 16.0.6001.1073
    German UI

    I got a workbook (100secsToOpenLOyes.xlsx) with ~600 sheets and ~4100 ListObjects.
    It takes ~100 sec in avg to open which I consider to be tooooo long.
    File is stored on SSD.
    While opening 1 CPU is running at 100%

    The corresponding file (100secsToOpenLOno.xlsx) with unlisted ListObjects is, of course, a bit smaller (5.4 MB) and…

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  4. Multithread MMULT

    Calculation time for multiplication of large matrices in Excel can be greatly reduced on multiple thread processors by breaking the array formula into multiple parts as follows:

    Array Name & dimensions (Rows x Columns)
    MatrixA = MxN
    MatrixB = NxP
    MatrixC = MxP

    Existing method:
    MatrixC = MMULT(MatrixA,MatrixB) = MxP.
    Currently a single array formula will only calculate on one thread.

    Proposed:
    Retrieve number of processor threads T from the Advanced Options.

    Split MatrixA horizontally by rows into T parts.
    MatrixA1 = (M/T)xN
    MatrixA2 = (M/T)xN
    ...
    MatrixAT = (M/T)xN

    MatrixB is unchanged.

    Split MatrixC horizontally by rows into T…

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  5. Hiding a PivotField deletes right PivotChart Axis

    Have a PivotChart with 2 series bound to the left AxisGroup and 2 series bound to the right AxisGroup.
    Now hide the PivotField corresponding to one of the series bound to the left AxisGroup.
    ==> Excel deletes the right Axis and binds all series to the left AxisGroup; see Demo macro.
    That is not desired.

    Sub Demo()

    Dim lcCO As Excel.ChartObject
    
    Dim lcLO As Excel.ListObject
    Dim lcPT As Excel.PivotTable
    Dim lcWS As Excel.Worksheet

    Workbooks.Add
    Set lcWS = ActiveSheet
    With lcWS
    .[a1] = "Time": .[b1] = "Left1": .[c1] = "Left2": .[d1] = "Right1": .[e1] = "Right2"
    .[a2] = "0:00:01": .[b2] =…

    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 →
  6. Right click on cell options in the list - need some more options

    I would like to have more options to select after i right click a cell in Excel.
    Always wondered why not more? And the ones in there are not what i would really choose.
    One i would definitely add is the REPLACE. I always have to go up to the right to click replace. Would be so much easier to right click cell and select replace. Also would be nice to have set Print Area there too so i could select it there.
    The current choices are shown below. Need more choices. The 2 i recommend would be great to…

    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 →
  7. manage pivotcache to reduce file size

    to used the same pivotcache for pivottable, to correct the misallocations

    Printing or reading allocations like relations in Access

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  8. Problem Activating Worksheets from Modal Form

    In Excel 2016 if a modal user form attempts to activate a protected sheet then it will not activate properly.
    This bug was also noted in Excel 2013 and appears to have been fixed in Excel 2016 for unprotected sheets but protected sheets still do not activate properly.
    The symptoms of an improperly activated sheet are that entering values will actually cause the value to be entered on the previously activated sheet. If that cell is protected (on the previous sheet) but not protected on the active sheet it will display that the cell is protected. Scrolling with the mouse…

    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  ·  Flag idea as inappropriate…  ·  Admin →
  9. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  10. saving to onedrive

    If I have 2+ excel files open, and I close one, confirm saving, then it uploads to onedrive. While this dialog box window is open, I'm locked out of my other excel sheets until the file finishes saving to onedrive. If the file is large (100+MB), then this can lock me out for several minutes.

    I'd like all excel file activity to be contained in that window, and not interrupt or prevent activities in the other excel file windows.

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

    We’ll send you updates on this idea

    1 comment  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  11. Place some indicator in the Row (1,2,3...) or Column (A, B, C...) header that there is data or formula within that entire row or column

    Before I begin to manipulate rows or columns, I check to see if my change will affect the data presentation elsewhere or include unintended information within my formula.

    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 →
  12. Fix Formula Bar not activating sheet when Find window is open

    Fix Formula Bar not activating sheet when Find window is open
    This bug is in 2013&2016: if you open 2 workbooks (side by side) and use the Find window to find items in workbook A and then click the formula bar of workbook B to enter the info you want to xfer into workbook B, the info will actually overwrite the 'found' cell in workbook A. Try it, it is actually kind of funny to see.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  13. Marking values presented more that once in filter window

    While working with purchase specifications, the same positions in differens rows often appear with different quantities in each row which should be summed up for sending a request. It would be very convenient to have values corresponding with more then one rows marked by font, color, etc. in filter window…

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

    We’ll send you updates on this idea

    6 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  14. Allow files to load from browser.

    Before the upgrade to Office 365 (I think) we had Office 2010. I was able to go to the file search window and select the file I wanted to open. A simple double click opened the file in Excel, Word, Power Point, or whatever.

    Now, the same action opens the application, but there is no file. I have to use the "File" menu within the program and search a second time to find the file and open it the long way.

    Please correct this error and do an update.

    Thanks,
    Kam

    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  ·  Opening and Saving Files  ·  Flag idea as inappropriate…  ·  Admin →
  15. Allow left and right vertical axes to sync their gridlines

    Suppose we have a left and a right vertical axis. One axis could have, say, five labels and tick marks, and the other could have seven. But there's no way to synchronize those items so that their gridlines can overlap.

    To implement this, you could offer a check box that would synchronize the two axes, or you could allow us to specify the number of tick marks on each axis so we could synchronize them ourselves. Better yet, you could offer both options.

    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  ·  Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
  16. Extend FIND and SEARCH to look for the Nth instance of a subtext in a longer text

    FIND and SEARCH currently will only find the first instance of a required text within a longer text and they always search from the beginning or to the right of a specified position. These functions would be much more useful if one could for example look for the third comma in a text or (most easily instituted by using negative counts) for the, say, third comma from the end of the text. So instance -1 of "a" in "banana" would yield a position of 6, the last "a" in the word, and instance 2 of "n" would yield 5, the…

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

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. multiple case statements in switch function

    The new switch function is great. It would be even better if multiple case statements could be grouped together. Maybe SWITCH(expression,{value1,value2,value3,...},result1,{value4,value5,...},result2,...) or maybe SWITCH(expression,SWITCHOR(val1,val2,...),result1,...).

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add conditional TEXTJOIN

    There is a popular user defined function publishe on the web called CONCATENATEIF (http://stackoverflow.com/questions/22639868/vba-user-defined-function-for-concatenate-if-by-rows)
    It extends TEXTJOIN to include a conditional.

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

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. Excel doesn’t register .xltx as a file type it is able to open

    Excel 2016 no longer registers .xltx as a file type it is able to open. This is clearly an error.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  20. Top 10 filter + extra selection of your choice

    It is not possible to compare some item in a group with the top x of the that group in the same pivot table. It is useful to give some context to that that item when we produce reports. e.g. top 10 economies by GDP + the GDP of Cameroon.

    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  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base