Feedback by UserVoice

Anonymous

My feedback

  1. 55 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Anonymous commented  · 

    A related error message actually lists a pivot table name such as pivotTable2. unfortunately, there can be multiple pivot table 2, AND you still dont know which worksheet PivotTable2 is on. Microsoft should require that error messages for tasks that cross worksheets - such as CTRL-Alt-f5 always include at least the first worksheet name that generated an error.

    An error occurred while saving the comment
    Anonymous commented  · 

    This is an amazingly obvious issue that Microsoft should have fixed long ago. My workaround is to copy the file, then delete one worksheet after another until the error goes away. then go back to the original and find the specific pivot on the sheet that when deleted stopped the error. Im sure the macro in the comments is simpler, but deleting one sheet after another is easy to remember.

    Anonymous supported this idea  · 
  2. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
    An error occurred while saving the comment
    Anonymous commented  · 

    Do you mean, instead of seeing counts or sums of data, to see the data labels in the count cells? if i understand what you are saying i agree.

  3. 10 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 
  4. 45 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Anonymous commented  · 

    likewise for columns - i often have formulas following the table for further processing, and my kludgy work around is to always leave at least one blank column, which means that visually the related formulas are separated from the pivot data.

    Anonymous supported this idea  · 
  5. 1 vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous shared this idea  · 
  6. 4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Anonymous commented  · 

    A multirow header would be excellent. This could also be used to maintain a row of notes explaining the purpose of the column or other useful information/warnings. In addition, sample formulas could be maintained there. i often have to paste-values on formulas (usually to reduce processing time but other reasons also).

    Anonymous supported this idea  · 
  7. 2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Anonymous supported this idea  · 

Feedback and Knowledge Base