This is a major productivity killer for power users such as finance teams, and current UX does not help exit this state efficiently.

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

Calculation Performance of iterative what-if Data Tables is unnecessarily slow. The reasons seem to be (in priority sequence):
- each iteration is using single-threaded recalculation rather than multi-threaded
- the overhead for the whole table calculation looks larger than it should be
- the process starts with a recalc, then does each iteration, then ends with a recalc: the first recalc is unnecessary
- if the values to be used in one of the iterations are the same as the start values the recalc for that set of values could be skipped

Ctrl + Z should work per workbook, not for all of Excel. I commonly have two workbooks open and work in them simultaneously, but when I use the undo shortcut it backs out through all of excel, instead of just the active workbook.

With high-end mice, having a higher poll rates greater than 200Hz will produce a lag - not fluid - while dragging the window

When Excel detects a range stored as text it gives a icon that you can click to convert the strings to numbers. This however is incredibly slow when applied to a range, it takes more than 1 sec per entry on my i5 windows machine. For a range of 1000+ this take unbearably long without opportunity to interrupt.

I wrote a VBA code that simply does a .value = .value and pastes the range back into the sheet. This is 100s of times faster that Excel's built in functionality. Please improve the built-in function's performance

Hi We need to open a new instance of Excel by deflaut each time we open an excel file. The following solution are not suitable.

you can start a new Excel instance (process) by doing the following:
run “Excel /x” (without quotes)
or the DisableMergeInstance regkey because it works only when you open excel first and then open the file. It does not works double clicking on an excel file. Don't give one of those solution (https://excelgorilla.com/excel/general/open-multiple-instances-excel/) as we need it to be by default as Excel 2010 behavior.

When I look at my task manager, Excel is usually only using approximately 14% of my CPU. I work with huge spreadsheets that take a long time to calculate. Why doesn't Excel use my idle processor cores / threads?

Remove "Translate" from Excel, you are ruining keyboard shortcuts. I do not need help translating "2" to "2" -- at least make this an option.

Excel 2003 and prior had a wonderful feature - they allowed a user to create multiple customized toolbars with custom icons picked from a selection library or created in an image editor.

Pity Microsoft did away with that feature and replaced it with the disaster that they call a ribbon. It is sub-optimal for a power user and takes up too much screen space on a laptop.

Bring back the multiple customizable toolbars and keep the Excel 2010 feature that allows you to export the customization to a file and import on another Excel 2010 installation.

When dragging the scroll bar with medium to large spreadsheets it is very laggy/choppy. This is annoying and the scrolling should be much more fluid.

You should be able to rearrange the order of the pinned Excel workbooks.

Excel usability could be improved significantly, by improving performance in the following scenarios:
1) Large file open / save processes should be multi-threaded, since new file format uses threadable compression.
2) UI responsiviness should be improved (but I think this applies to all XAML/UWP code apps). Excel 2007 with forms is still 3-5 times faster than new ui.
3) List views, could those use hashed lists and quicksort (yes, this would use more memory, but it would allow handling much larger lists and filters with 100 times faster than currently).

I am not entirely sure how this would be preformed but I have seen examples of excel using the processing power of a GPU to massively decrease calculation times when working with functions that can take advantage of the parallel processing that the GPU is capable off.