Feedback by UserVoice

Charles Williams

My feedback

  1. 73 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  · 
  2. 14 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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

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

    We’ll send you updates on this idea

    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  · 
  4. 64 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  · 
  5. 469 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    84 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    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

  6. 127 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    29 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    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.

  7. 31 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Excel for Mac » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    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.

  8. 63 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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

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

    We’ll send you updates on this idea

    Charles Williams commented  · 

    See uservoice suggestion Workbook level calculation

  10. 23 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 →
    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.

  11. 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  · 
  12. 49 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  · 
  13. 36 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Charles Williams commented  · 

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

  14. 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  · 
  15. 8 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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  · 
  16. 13 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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.

  17. 85 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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 commented  · 
    Charles Williams shared this idea  · 
  18. 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 supported this idea  · 
  19. 22 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  · 
  20. 13 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  · 
← Previous 1

Feedback and Knowledge Base