I would love it if I could find the number of cells that meet a certain condition. I'll use my current project as an example to better explain what I mean :)

So, I'm making a list of products and their prices, and I color-coded these products to make the whole sheet easier to understand. I then wanted to find the total number of blue vs red vs green cells, but I couldn't find a feature where it would count the number of cells of each color for me. There were a lot of products in this project, so I didn't really want to count them individually, but that's what I ended up doing. I'm sorry if this is already a feature! If it is, then my suggestion then would be to make it a little more clear or easy to see. It is a pretty niche feature that wouldn't get used often, but it would be nice!

Many years ago (many versions of Excel ago), Excel used to integrate the Goal Seek function into a graph so that you could "grab/drag" a graphed value (say, the height of a bar, or a point on a broken line graph) and actually move it up or down (increasing or decreasing the graphed value). If that value came from a directly entered value in a cell (say the number 10), then Excel would give me the option of changing the "10" to a value that matched the movement on the chart. If on the other hand, the graphed value came from a FORMULA, then Excel would intelligently activate the Goal Seek function and ask me WHICH cell in the formula chain I want to mess with to get the end result (the graphed value) to change to the new point on the graph. It was VERY useful for the kind of work I do. But for some reason that functionality disappeared, I believe, betwen the 2003 and 2007 versions of Excel (around the same time Excel hid 'Goal Seek' in the 'What-If Analysis' menu). No explanation has been given for that--wish it would come back!

License is Office 365 Business Premium | Version 2003 Build 16.0.12624.20348 (64bit)
Freshly installed Office on a HP Wind10 Core i7 10th Gen.
Default language installed is English + Swedish Language Pack installed and integrated with the application.

The default language is set to Swedish already. When we type "January" on cell A1, we drag the cell down and it automatically flash fills until December seamlessly. However, doing it in Swedish language doesn't work, ie, typing "Januari" from cell B1 and dragging it down and manually selecting Flash Fill, it does not automatically populate all the months of the year giving an error: "We looked at all the data next to your selection and didn't see a pattern for filling in values for you. To use Flash Fill, enter a couple of examples of the output you'd like to see, keep the active cell in the column you want filled in, and click on Flash Fill Button again."

It keeps on showing this error even after filling out "Februari" on B2,highlighting both cells and drag it down until December. Same error is shown.

Please make this feature available soon!

Let us say, there are an original excel file and a destination excel file. I wish to use the vlookup function in the destination file to collect certain data from the original file. I would like the function working even when the original file is closed. Currently, the vloopup function works with closed original files only if references like $A$1:$A$11 are used. It would be indeed excellent when you make the stuctured references to formatted tables like DeptSales[Sales Amount] working when the original file is closed.
Also, I tried just a simple structured reference to a formatted table in the original file without any functions. It worked only when the original file was open.
This problem is well illustated with images here (the language is German): https://bork.blog/2019/01/31/excel-sverweis-und-formatierte-tabelle/

So, now, the structured references work only when the original file is open. If you make them working when the original file is closed, it would help to reduce errors in links between the files. This would be especially important, if the files are used by different people.

Currently I can use the 'Select Objects' tool to select multiple Shape objects in a worksheet. However, if I try to use the same tool to select multiple Shape objects in a Chartsheet it just doesn't work

As soon as I depress the mouse button to start selecting objects prior to dragging a selection area over the objects of interest it just selects the chart object precluding me from being able to drag a selection area over the Shape objects that I wish to select sitting on top of the chart object

Furthermore; shapes objects I draw in a worksheet appear in the objects 'Selection Pane'; shape objects I draw on a Chartsheet do not appear in the 'Selection Pane'

Please allow the user to select multiple shape objects sitting on top of a Chart; this used to work fine in Excel 2010