pivot table
 

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,

Is it lookimg at the correct range?

"Pivot table data import problems" <Pivot table data import
wrote in message
...
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,

I expect the problem is with your data or the table setup.

On Wed, 5 Oct 2005 11:49:03 -0700, "Pivot table data import problems" <Pivot
table data import wrote:

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,

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 he

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

Pivot table data import problems wrote:
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,


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html