Feedback by UserVoice

Charles Williams

My feedback

  1. 99 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Charles Williams commented  · 

    There are several good addins for exploring/debugging formulas (FastExcel Explorer Pro, Arixcel ...). But making a good editor as an addin is very difficult so I absolutely agree that improvement is needed, particularly for LAMBDA. Some ideas include:

    Indent on/off and or sub-expression treeview
    Smart Indent understands IF etc
    Color code the result path from IF, IFS, CHOOSE etc
    Color the syntax and formula precedents
    Double-Click an offsheet reference does a GoTo
    Built-in Evaluate option that handles scalars, arrays, ranges, functions including Lambdas and Lets, with ability to filter array results
    Debug option that handles recursion
    Option to expand/contract defined names, LETs and LAMBDAS into their definitions
    Formula comments
    Function argument intellisense and Help
    Intellisense for Lanbdas and UDFs
    Forward and backward step-by-step debug
    Integrated precedents and dependents
    ...

    Charles Williams supported this idea  · 
  2. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charles Williams shared this idea  · 
  3. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charles Williams shared this idea  · 
  4. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Charles Williams commented  · 

    @Samk - could you try downloading and using my ShowMemory tool?

    (see https://fastexcel.wordpress.com/2016/11/27/excel-memory-checking-tool-using-laa-to-increase-useable-excel-memory/ for explanation)

  5. 858 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    This is a great suggestion, and we want to keep the interest going. Thanks to everyone who has already voted and commented on the suggestion to have an option for the default paste behavior in Excel.

    Sorry that we’ve been slow to comment and update the status on this one.

    Steve K [Excel]

    Charles Williams supported this idea  · 
  6. 287 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Charles Williams commented  · 

    Its probably better to have total type as a parameter like aggregate.

    Floating or fixed column totals: Totals each column of the Table_Range/Expression.
    Floating produces a copy of the Table_Range/Expression with a horizontal array of the totals of the columns appended at the bottom.
    Fixed produces a fixed position horizontal array of the totals of the columns without a copy of the table/range.

    Dynamically adjusts to the number of rows and columns in Table_Range

    TOTALS (Table_Range [, Exclude_Cols] [,TotalTypes], [Fixed] )

    An error occurred while saving the comment
    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.

    An error occurred while saving the comment
    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  · 
  7. 284 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charles Williams supported this idea  · 
  8. 20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Charles Williams commented  · 

    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

  9. 129 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charles Williams supported this idea  · 
  10. 830 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    151 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Charles Williams commented  · 

    My 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.htm

    But its a chargeable product

    An error occurred while saving the comment
    Charles 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.htm

    But its a chargeable product.

  11. 176 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    42 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Charles Williams commented  · 

    You 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.htm

    But its a chargeable product.

  12. 64 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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

  13. 29 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Charles Williams commented  · 

    See uservoice suggestion Workbook level calculation

  14. 24 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Charles 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.

  15. 12 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Excel for the web » Performance  ·  Flag idea as inappropriate…  ·  Admin →
    Charles Williams shared this idea  · 
  16. 50 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charles Williams supported this idea  · 
  17. 36 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Charles Williams commented  · 

    Surely a simpler solutiin is NOT to use .text in the furst place?

  18. 3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charles Williams shared this idea  · 
  19. 9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    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 Excel-based 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  · 
  20. 17 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Charles Williams commented  · 

    Excel does do multi-threaded calculation, but some things are still single-threaded including: VBA, VBA UDFs, INDIRECT, GETPIVOTDATA, What-If Data Tables, Cube Functions, Circular References etc.

    If you are using a 4-core hyperthreaded CPU so 8 logical cores 14% means single-threaded. I am afraid that the only solution is to rebuild the workbook avoiding single-threaded things.

← Previous 1

Feedback and Knowledge Base