Pivot table refreshes only certain range of data
Posted on 2011-09-21
I have never used a pivot table before but need to get this report refreshed. Pivot table is in (Excellworkbook1).sheetA
The pivot table is pulling data from a different spreadsheet (Excellworkbook2).sheetB
There at 1430000 plus rows in this sheet (Excellworkbook2).sheetB.
. When I refresh the on the pivot table it works fine and the data is displayed correctly.
Now I have added some more data to (Excellworkbook2).sheetB 165000 rows. Whne i hit refresh the pivot table gets refreshed but it pulls data only for 142000 rows. How do I make it pull all the data in (Excellworkbook2).sheetB.
It just pulls 142000 rows.
Can anyone please help.