pivot table missing rows?

P

puck1263

Hell
I have a pivot table that is linked to a worksheet in Excel 2010. Th
worksheet with the table and the worksheet with the source data are i
the same workbook
In the pivot table I have two columns showing defect sum by month/year.
Row label is month/year and values are sum defects. (month year is
column in the worksheet and defect count is also a column, so thi
should be very simple). So each row of the pivot table is a differen
month with the sum next to it

The pivot table goes down so far and then starts cutting off row
(months). It's not showing all the data

The source data for the pivot table is the whole column for all column
in the worksheet, so that's not it
I don't have any filters on the pivot table
Auto calc is on and I "refreshed all

I don't get it. Any thoughts
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top