Pivot Table doesn't display all data

  • Thread starter Thread starter Gator
  • Start date Start date
G

Gator

It displays all the data for example on month of data and will not pick up
all the data from another month?
 
Maybe you added new data to the source table, and those rows aren't
included in the pivot table's source. To check:

Right-click on a cell in the pivot table
Click on PivotTable Wizard
Click Back, and make sure all the rows are included in the source range
Click Finish

If data will be added to the source table, you can create a dynamic
range, and base the pivot table on that, as described here:

http://www.contextures.com/xlPivot01.html
 
You must log in or register to reply here.

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

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
2003 Pivot Table Filter (items dropped in the Page Fields) 1
pivot table data 2
Linking Data from Pivot Table 1
How do I save Pivot Table Data 4
How do I replace/select new fields in pivot table using a macro? 1
Pivot Table 2
Excel 2003 Pivot Formatting 2

Back
Top