Charles Williams
My feedback

73 votes15 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charles Williams supported this idea ·

14 votes

171 votes23 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charles Williams commented
@Harlan Grove ,
SUMCOLS and SUMROWS etc are not floating totals, they are static so your are correct: it would make no sense to position them below or to the right of a dynamic array.. (I also wrote a TOTALS function which IS dynamic if floating totals are wanted)
With dynamic arrays the syntax B5# returns the spilled dynamic array whose top left corner is B5
The problem with filling a formula right or down is that it does not expand/contract with the dynamic array: thus defeating the purpose of the dynamic arryay.
. It is often possible to construct expanding/contracting formulas using things like MMULT, but the resulting formula is very ugly and unintelligible to the average user.
Charles Williams commented@Kevin,
Would be nice to address your DA Table problem, but that would not solve the problem for general DA totals.
Charles Williams shared this idea · 
64 votes5 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charles Williams supported this idea ·

469 votes
Thanks for all your comments and votes supporting this suggestion. We are in the planning stages for this feature to be added to Excel for Mac.
Thanks – Steve K [MS Excel]
Charles Williams commentedMy addin product FastExcel Manager Pro for Mac has a better Evaluate Formula tool than Windows Excel (Formula Explorer Pro).
http://www.decisionmodels.com/fxl_MgrProMac.htmBut its a chargeable product

127 votes
Thanks for all your comments and votes supporting this suggestion. We will continue to monitor this forum.
Thanks – Steve K [MS Excel]
Charles Williams commentedYou can use my addin product FastExcel Manager Pro for Mac:
This contains Name Manager Pro which has a lo more features than the standard Windows Name Manager.
http://www.decisionmodels.com/fxl_MgrProMac.htmBut its a chargeable product.

31 votesCharles Williams commented
My addin product FastExcel manager Pro for Mac has a great formula auditing and exploring tool (Formula Explorer Pro)
http://www.decisionmodels.com/fxl_MgrProMac.htmBut its a chargeable product.

63 votes10 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charles Williams commented
I think Formula Explorer Pro does the analysis and debug part of this suggestion:
The overview video is here https://vimeo.com/309910367
Download from here http://www.decisionmodels.com/fxl_mgrpro_beta2.htm

27 votes2 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charles Williams commented
See uservoice suggestion Workbook level calculation

23 votesCharles Williams commented
The base problem is that Excel does not have a calculation method that only calculates a single workbook when multiple workbooks are open, so many calculation settings are global but set from the first visible workbook opened.
AFAIK Excel has always worked this way for the last 20 or so years.

12 votesCharles Williams shared this idea ·

49 votes10 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →Charles Williams supported this idea ·

36 votes2 comments · Excel for Windows (Desktop Application) » Macros and Addins · Flag idea as inappropriate… · Admin →Charles Williams commented
Surely a simpler solutiin is NOT to use .text in the furst place?

3 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charles Williams shared this idea ·

8 votes4 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →Charles Williams commented
All of these suggestions point at the same problem: the current way Excel handles calculation mode is very confusing and restricted. but MS cannot change the existing method without breaking millions of Excelbased applications and workbooks.
so the only solution I can see is to add one or more new calculation options that allow you to override the current settings whilst the new options are in effect.
My suggestions for these are:
1. Calculate Active Workbook only using its own workbook calc mode
2. Set Initial Calculation Mode (First workbook  which is the current method, Auto, Manual, Auto except Tables)Charles Williams shared this idea · 
13 votes2 comments · Excel for Windows (Desktop Application) » Performance · Flag idea as inappropriate… · Admin →Charles Williams commented
Excel does do multithreaded calculation, but some things are still singlethreaded including: VBA, VBA UDFs, INDIRECT, GETPIVOTDATA, WhatIf Data Tables, Cube Functions, Circular References etc.
If you are using a 4core hyperthreaded CPU so 8 logical cores 14% means singlethreaded. I am afraid that the only solution is to rebuild the workbook avoiding singlethreaded things.

85 votes4 comments · Excel for Windows (Desktop Application) » Performance · Flag idea as inappropriate… · Admin →
Many thanks to Charles for taking the time to analyze this in such detail and start the discussion about improving the efficiency of data tables. Please vote for this issue if it’s important to you so we can prioritize it appropriately.
Thanks,
Steve (MS Excel)Charles Williams commentedSee my blog post for more details
https://fastexcel.wordpress.com/2015/12/16/excelwhatifdatatablesfastercalculationwithvba/Charles Williams shared this idea · 
9 votes2 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Charles Williams supported this idea ·

22 votes4 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Charles Williams supported this idea ·

13 votes0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charles Williams shared this idea ·
I agree. One way of doing it is to create a TOTALS(dynamic array create formula) function that wraps the formula that creates the dynamic array. The output is then the dynamic array plus an extra row of totals.
See http://www.decisionmodels.com/fxlv4_speedtools_beta1.htm for a working example of TOTALS