pivot table

  • Thread starter Pivot table data import problems
  • Start date
P

Pivot table data import problems

My pivot table is not reporting accurate results. For example, it will show
total data points as 107, when my data really shows 160. Does anyone know
what's happening?

Thanks,
 
D

Debra Dalgleish

New rows of data may not be included in the pivot table, even if you
refresh it. You can adjust the source range:

Right-click on a cell in the pivot table, and select Wizard
Click the Back button
In step 2 of the pivot wizard, select the entire range that you want in
the pivot table.
Click Finish

Or, you could use a dynamic range for the pivot source. There are
instructions here:

http://www.contextures.com/xlPivot01.html
 
Top