LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 8th 12, 05:25 PM
Junior Member
First recorded activity by ExcelBanter: Feb 2012
Posts: 20
Default pivot table missing rows?

I have a pivot table that is linked to a worksheet in Excel 2010. The worksheet with the table and the worksheet with the source data are in 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 a column in the worksheet and defect count is also a column, so this should be very simple). So each row of the pivot table is a different month with the sum next to it.

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

The source data for the pivot table is the whole column for all columns 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?

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Value filter missing in pivot table Ben B.[_2_] Excel Discussion (Misc queries) 4 January 18th 11 10:44 AM
Pivot table missing column Pivot Table missing column Excel Discussion (Misc queries) 0 November 19th 09 04:38 PM
Pivot table missing customers cjborntorun Excel Discussion (Misc queries) 1 July 1st 08 03:01 AM
missing value in a pivot table dawn_dudley Excel Discussion (Misc queries) 3 June 30th 07 09:24 AM
missing data on Pivot table Aannd Excel Discussion (Misc queries) 1 December 21st 04 01:05 AM

All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017