The issue with "There's a problem with the clipboard..." while copy and pasting is still as issue. I was using Office 2010 and there was no problem. I am now using Office 365 and this issue is prevalent. It manifests itself when pasting a value from a cell containing a formula and disappears when disabling Live Preview. I was able to copy and paste "normal" cell contents fine before the error message appears so the official response of "another program has locked the clipboard" doesn't really hold up. It looks more like Excel has locked the clipboard from itself.

There is no reason for this issue to have hung around as long as it has and it really should be fixed, especially if Microsoft wan't to keep selling Office as a subscription.

Allow users to create formulas and that perform specified operations with data/values from only cells with a chosen background color, from a range of cells.

For example, in a range of 10 cells (A1:A10), only 3 cells have been colored yellow (either by the user or by a specified condition). A user can create a formula, such as =SUM or =COUNT or =AVERAGE, that will only use the cells colored yellow to determine the result. All other cells in the range, regardless of background color, will be excluded from the formula's result.

Alternatively, the same functionality can be achieved based on font color, such as values colored red.

Ideally, both methods (cell background or font color) should be implemented since the use of color is a very important and natural way users identify special or standout data. Even on paper we use highlighters of various colors, or red-ink pens to identify data or values of special importance. The most powerful and useful spreadsheet software available should also have this capability, without requiring users to develop complex VBA scripts and code.

When you have one calculation-heavy workbook and distribute it to other people, it would be best if you could turn off calculation for only that workbook, without affecting the other workbooks these users are working on. It is confusing and outright dangerous in potential consequences that suddenly their workbooks do not calculate anymore. On the other hand, if the calculation is on, their whole excel freezes for a considerable amount of time every few keystrokes.

Suggestion: Allow for a transparent Manual vs. Automatic Calculation setting by workbook vs. a global setting.
There should be a popup when you open the workbook if the calculation has been turned off by the previous user of the document, giving you the choice to accept this (applicable only to the workbook) or activate the calculation again.

A function which returns ordinal position of one specific element in an array as a number. Alternative name occurrence.

So for example if the array was like this
A1 Dave
A2 Fred
A3 Jim
A4 Dave

Then Ordinal(A1:A4,A1) would return 1 eg the 1st Occurence of Dave
Ordinal(A1:A4,A2) would return 1 eg the 1st Occurrence of Fred
Ordinal(A1:A4,A3) would return 1 eg the 1st Occurence of Jim
Ordinal(A1:A4,A4) would return 2 eg the 2nd Occurrence of Dave

Function Format something like
Ordinal(lookup array, lookup cell, optional reverse)
Lookup array could be vertical with a width of 1 column or horizontal with a height of 1 row.
Lookup cell must be in the lookup array
Reverse would count from the bottom or right rather than top or left.

Attached picture is a more concrete example.
Should work in Tables too.

The only work around I have for this is a real cludge and relies on the list being sorted. Personally I have needed something like this a few times.

It could also be useful for check that data entered doesn't contain duplicates, although can also use countif function for that.

To syntactic sugar extensions would be FirstOrdinal and LastOrdinal which return true if the element is the first or last respectively, but this would be possible with the Ordinal function and Countif function within an If function

A slight longer example in the screen shot (done by hand)

When a person's display name contains a bracket character (such as a departmental suffix) this bracket is included in the folder name of a OneDrive shared folder. When a recipient of that OneDrive shared folder attempts to modify an Excel spreadsheet and save it back to the shared folder, they will see an error that the file could not be saved due to invalid characters in the filename or path. If Excel could support the bracket character in the filename or path this would no longer be an issue. (An alternative solution would be to allow admins an option to have OneDrive shared folders use the owner's UPN rather than their display name.)

Kindly Find Attached 'Product Names List' Where In There Are Different List Of Items ,I Want Excel To Show Me A Dropdown List With Automatically View Item Name That Match The Words While Typing So Taht We Can Select With The Arrow Key And Press Enter To Work With Particular Item From List,

I Have Tried With Searchable Dropdown Down List But Its Not Giving Me A Eaxact Solution How I Want .

Suppouse I Start Typing In Cell, Name Of Item “ACID ____ ” Exel Should Show A Dropdownlist With All The Item Name That Match ACIDnock,ACIDout,ACIDout Lemon ,ACIDout Regular.

Please Share A Solution

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 via the JavaScript API and Command Add-in would offer powerful opportunities for new applications and extending Excel functionality.

There is a bug with the processor usage, which extends up to 99% in some special situations.
Since the latest version of the semi-annual channel, there is a new bug, which is also in the latest version of monthly channel.
When you are opening a new excel sheet and copy one or more cells then you can start playing a little "processor-game". On the bottom there is a slide control, when you push it to the verry left (over the table sheets) the processor usage will grow up to 99%, when pushing it back to the right, the usage decreases. You can slide it as long as you want.