ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table doesn't display all data (https://www.excelbanter.com/excel-discussion-misc-queries/193430-pivot-table-doesnt-display-all-data.html)

gator

Pivot Table doesn't display all data
 
It displays all the data for example on month of data and will not pick up
all the data from another month?
--
Gator

Debra Dalgleish

Pivot Table doesn't display all data
 
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 he

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


Gator wrote:
It displays all the data for example on month of data and will not pick up
all the data from another month?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com



All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com