What I would like to see in Excel 2016

Fazza · Jul 27, 2015

Minor issue

I'm using Excel 2013 in my current workplace. When using basic filtering, one handy thing is being able to drag the filtering window. Annoyingly, when next filtering the window has reset to its default. It'd be good if it remembered its previous re-sizing.

The name manager does remember its resize.

Drrellik · Jul 27, 2015

Re: Minor issue

I would like to be able to turn on and off sheet calculations under the cell properties for each cell.
would help non VBA users with dates and times only updating when they wanted them to.

Scott Huish · Jul 29, 2015

Re: Minor issue

Customizable User Interface Color Schemes

mfexcel · Aug 6, 2015

Re: Minor issue

Intelligence to detect when a user wants to input a date or a text. For example, if a user input "Oct 15", Excel asks the user whether s/he wants to input
1) Date as: 1st October, 2015
2) Date as: 15th October of current year
3) Text as "Oct 15"
Option: Remember this option for the rest of the column.

Drrellik · Aug 8, 2015

Re: Minor issue

How about the Insert Function be able to assist with combined functions. so when you enter an argument for the INDEX function and for your Row you type Match and the Function argument would understand and continue to assist you are you walked through you formula. and not just for that one example but for any argument.

Terp1 · Aug 10, 2015

Re: Minor issue

Ability to change the Alt shortcut key for items in the ribbon without using VBA or an add-in. E.g., change Paste Special from Alt-H-V to Alt-A-Z.

dhsilv2 · Aug 29, 2015

Re: Minor issue

Count unique ifs!
Allow a user to filter based on another range. For example if I have 500 accounts I want filtered out of 100,000 rows, I can just select them instead of doing something like a vlookup or match to find non N/A's and then filter (the number of times a day people do this is absurd)
Create a basic VBA UI to allow users to start creating macros without knowing VBA. If Access can create SQL code based on a UI, there's no reason excel can't allow at least basic functionality.
Many to many joins on pivot tables and power pivot (or remove both and force users to use a database tool).
Improve performance or Arrays. something like {sum(if(if())} instead of saying adding 4 sumifs to some 4 columns is really easy to do, and honestly easier to read, but performance can be horrible.

DocAElstein · Sep 12, 2015

. Hallo.
Good Day to you.
.......
As a general improvement / advancement I would like to see would be to increase the “strange” limit of 255 characters in the VBA Evaluate Method
=Evaluate( StringArgument )
, which ( I find strange ) applies both to the StringArgument and the Output string
http://www.mrexcel.com/forum/excel-...ons-evaluate-method-255-character-limit.html?

.. maybe there is some fundamental limit here and it is inappropriate for a “simple “ version Update. ??

......................
Any comments? To aid, -
. If I may a short clarification:
. If I understand correctly, the simplest explanation of the VBA Evaluate Method is that it will act on its string argument as if it were a Spreadsheet formula in a cell. So like
=Evaluate(“ Put in here what would be in the spreadsheet cell ” )
...
..
But it has the extra advantage over the Spreadsheet that you can include some VBA Code in that argument to help build up that string argument...

=Evaluate(“ Put in here what would be in the spreadsheet cell ” “ & Bit of VBA Code & “ ” )

.... so really powerful, or would be if not having that character limit.
.
. Wot I mean .. consider this code Sub AlanEvaluate() where I attempt to mimic the VBA Evaluate Method. It makes a very long string formula, pastes that into the cell and then retrieves the spreadsheet evaluated answer, ( a bit more detail to the code is given in the above Thread reference. )
. The equivalent VBA Evaluate Method , line , at line number 120 fails due to the 255 limit ( in this example I am talking about the 255 Limit to the string actually seen by VBA in the =Evaluate( ) code line )

Code:

Rich (BB code):

Sub AlanGotEvaluate()
10  Dim wks As Worksheet: Set wks = ThisWorkbook.Worksheets("Limit255") 'Sheet Info
20  wks.Range("B2:D6").ClearContents 'Clear contents in output Range
30  Dim lr As Long: Let lr = 34 '34 chosen to make the evalute String a bit longer than 255 Characters and cause VBA Evalute Method to fail.  ( 33 Works )
40  Dim rngE As Range: Set rngE = wks.Range("A1:A" & lr & "") 'Input Range
50
60  'Build string for Evalute "One liner" which is just a bit too long for Evalute Method String Argument ( 258 )
70   Dim r As Long 'Variable for row
80   Dim EvalArgStr As String '
90      For r = 1 To lr - 1 'lr Step 1
100     Let EvalArgStr = EvalArgStr & "" & wks.Range("A" & r & "").Address & "" & "&"" ""&" 'Concatenate lines with space between
110     Next r
120  Let EvalArgStr = EvalArgStr & "" & wks.Range("A" & lr & "").Address & "" 'Concatenate last cell value without space
130  Let EvalArgStr = Replace(EvalArgStr, "$", "") 'Remove "$" in string to shorten it a bit
140  Let EvalArgStr = "=" & EvalArgStr 'Include the = so as not to rely on the Implicit Default, which makes substitution in Spreadsheet easier.
150
160 'Output size of Evaluate string argument, and Output Evaluate Argument String as Text
170 Let wks.Range("B2").Value = Len(EvalArgStr) 'Output character length of Evaluate Argument String
180 Let wks.Range("C2").Value = " " & EvalArgStr 'Output Evaluate Argument String ( Add a space so that it comes out as a Text String )
190
200 'Output result of VBA Evalute Method and Check size of the evaluated String THESE LINES WILL ERROR
210         '    Let wks.Range("C6").Value = Evaluate(EvalArgStr) 'Output results of "Evaluate Range one - liner" to Cell C6
220         '    Let wks.Range("B6").Value = Len(wks.Range("C6").Value) 'Output character length in cell C6
230     'Let wks.Range("B6").Value = Len(Evaluate(EvalArgStr))
240
250 ' "Alan Evaluate" Put string Formula into cell and retrieve Spreadsheet Evaluate result.
260 Let wks.Range("D2").Value = EvalArgStr 'Output Evaluate Argument as Formula
270 Dim AlanGotEvaluate As String: Let AlanGotEvaluate = wks.Range("D2").Value 'Retrieve Spreadsheet Evaluated Value
280 Let wks.Range("D6").Value = wks.Range("D2").Value 'Paste out Spreadsheet Evaluated Value

End Sub

Code works on this Spreadsheet

Using Excel 2007
[Table="width:, class:head"][tr=bgcolor:skyblue][th]_Row\^Col[/th][th]

A

[/th][th]

B

[/th][th]

C

[/th][th]

D

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:skyblue]

1

[/td][td]

1

[/td][td]Character Count[/td][td]String[/td][td]Formula[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:skyblue]

2

[/td][td]

1