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.

Filtering:

When filter button is pressed on any column, the drop down menu should -

1. Show number of recurrences of each unique value displayed in the drop down list, in brackets on the right side of each unique value, in grey font. This will be very helpful in knowing, by just dropping down filter menu, how many records are there for each of unique values shown in the filter drop down list. Currently we have to filter each value and run a countif formula in a help column or look at the bottom line that shows how many records are filtered.




2. Show two buttons (maybe at top side of drop down menu), one down arrow button for selecting next value for filtering, and other up arrow button for selecting previous value for filtering in the list. This is very helpful when we are reviewing data by filtering one by one values in a column. Currently we have to scroll down to the value which is filtered, uncheck that and check the next value. Very tiring at times.

In the good versions of Excel (prior to 2007) one could open multiple workbooks in the same window. Now, one has multiple instances of Excel (and every other Office app) whenever one opens more than one document / spreadsheet.

Again, here are the issues:

1. Stability - I experience ~3X Excel crashes in 2016 (SDI) as compared to 2010 (MDI)


2. Screen Space / Real Estate - Drastically reduced screen space when each workbook requires its own Ribbon, Quick Access Toolbar and Formula Bar


3. Toolbar to Workbook Confusion - One Ribbon + Quick Access Toolbar + Formula Bar to control all workbooks is far less confusing (MDI)


4. Navigation Between Workbooks - *a. With MDI, Ctl+Tab and Ctl+Shift+Tab worked flawlessly to cycle (forwards/backwards) through all open workbooks in a single instance of Excel. Using the same key combinations in SDI, I always see a screen “blip” of the last used non-Excel program – why? Even worse, sometimes it cycles a non-Excel program into the mix. When I’m trying to cycle between two workbooks, I do NOT want Windows Explorer thrown into the cycle!


5. Links (across workbooks) - Ability to update links between workbooks is less flexible – sometimes you want links to update and sometimes you do not. In the past, we could easily open a new/separate instance of Excel and prevent links from updating between workbooks. Now, it is far more difficult to open a new/separate instance of Excel and it is more confusing to work between 2 instances


6. VBA – macro instability - Running macros between multiple Excel Workbooks is not consistent in SDI – sometimes it will choose the next workbook, sometimes it does not. There are a lot of comments on this topic. I can only imagine the countless hours of VBA work that have been destroyed by the forced SDI


7. Closing Workbooks - With MDI, you could close and save ALL workbooks with a couple of mouse clicks. In SDI, you must close and save each workbook individually. If you have ~10 large workbooks open at once this will require you to stay engaged in the process as you will be forced to wait for each workbook to save, so you can save and close the next workbook (another massive waste of time/productivity).


8. Opening Workbooks - *With MDI, we could count on workbooks to open and be sized where we had saved them. Now, they open in the exact same size and cascade – WHY? How would you like to go to your desk every day, only to find everything in a different drawer? That’s not where you put it last time you used it?… so why keep moving things on us?


9. Minimize/Maximize Workbooks - Per post on 6-Aug-2018, working with 12 workbooks, with MDI you could use 3 mouse clicks, but with SDI it now takes 18 mouse clicks. Do you think the customer desires to use their mouse more?

Excel 2016 switched the order of the pinned files from alphabetical to most recently used. IMHO, that was a big improvement. Apparent;y that change has been reversed.

Pre-2016 I only pinned 4 of 5 files that were hard to find or only used monthly. Files I used Daily I pulled from the recently used files.

In 2016 I switched to pinning about 20 files. The ones I used daily or weekly are always near the top. The ones I use monthly are farther down but easier to find than going to the various directories.

For me, going back to the alpha sort makes files harder to find.

PS: When this changed back to alpha I assumed I had gotten a bug or entered a time warp. I spent some time looking for an option that had changed but couldn't find anything.

Currently if you apply conditional formatting to a named range (i.e.. a range named via the Name Manager or a table style named-range), the value in the "Applies to" column of the Condidtional Formatting Rules Manger will revert the named range to its absolute cell reference.

eg. "Applies to: =Table1[Column3]" becomes "Applies to: =$C$2:$C$7".

Apart from being more difficult to read, it creates other complexities. e.g. if I happen to copy/paste a cell into this range, it creates a mess in the rules manager, creating a new rule for each cell pasted.

e.g. if my named range is 'Table1[Column3]' which corresponds to cells $C$2:$C$7, and I copy say cell C2 and paste it into C8, then in the rules manager another line is for some reason added with the same rule. So now I have one rule for range '$C$2:$C$7' and another one for '$C$9'. Why?!

Having one line for the named range would make things so much more simple.

In Excel 2010 we were able to highlight numbers and have their sums displayed in the grey status bar towards the bottom of the sheet. Working with 2 monitors, this feature was very helpful.

After upgrading to Excel 2016 the status bar of the non active/selected workbook disappears instead of the sum being viewable of the non active workbook.

The feature was helpful for at least 2 open excel instances where we can view the sum of the non active workbook and it would be great to have back instead of being forced to click in out of each workbook to see the status bar sums.

When a filter is applied in a header row, the filtered column(s) gets a "Funnel" icon to indicate that it has been filtered. In a row where multiple filters have been applied, if, in addition to having the funnel icon, the "filtered" icons came in a different colour - say a limited choice of colours for the user to pick from - then that would make the filtered columns easier to spot. For a user looking for the first time at a file and wanting to find what columns have been filtered, having the "filtered" icons in a different colour from the rest of the "drop-down" like icons that are attached to the header row would enable the user to more easily spot the filtered columns. Just saying.