Feedback by UserVoice

Charles Williams

My feedback

  1. 7 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  · 
  2. 7 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. 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)

  4. 728 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  · 
  5. 260 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  · 
  6. 244 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  · 
  7. 18 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

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

    We’ll send you updates on this idea

    131 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.

  10. 161 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    39 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.

  11. 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

  12. 28 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

  13. 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.

  14. 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  · 
  15. 51 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  · 
  16. 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?

  17. 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  · 
  18. 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  · 
  19. 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.

  20. 91 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Many thanks Charles for analyzing and raising this issue! Also, many thanx to folks for voting as well. Please continue to vote for this issue if it’s important to you so we can prioritize it appropriately in the future.

    Thanx,
    Prash [MS Excel]

    An error occurred while saving the comment
    Charles Williams commented  · 
    Charles Williams shared this idea  · 
← Previous 1

Feedback and Knowledge Base