Exceljet

Quick, clean, and to the point

10 pivot table problems and easy fixes

With pivot tables, it's often the little things that are frustrating...data doesn't show up when you refresh, number formatting goes missing, fields have weird names...things like that. In this short video, we look at 10 common pivot table problems + 10 easy fixes. Here are the problems we look at:

  1. New data not included when you refresh
  2. You want totals and percent of total
  3. You don't want a data sheet
  4. You don't like the automatic field names
  5. Your number formatting gets lost
  6. You want to see the data behind a subtotal
  7. Grouping one pivot table affects another
  8. Refreshing a pivot messes up column widths
  9. Field headings make no sense and add clutter
  10. There are blanks in your pivot table

Are you having other problems with pivot tables? Leave a comment below we'll try to help you out.

This is the 3rd video in this series on Pivot Tables. Here's the full list:

  1. Why Pivot Tables? - Because they are way faster than even a pro user
  2. What are Pivot Tables good for - 3 pivot examples
  3. 10 pivot table problems and easy fixes  <- this video
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables