![]() |
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 |
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