| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display comments (words) as my data in a pivot table? | Excel Discussion (Misc queries) | |||
| Pivot Table (display source data) | Excel Discussion (Misc queries) | |||
| Using Pivot Table to Display Filtered Data Only | Excel Discussion (Misc queries) | |||
| pivot table data display in cell | Excel Discussion (Misc queries) | |||
| Pivot Table: Display data | Setting up and Configuration of Excel | |||
Hybrid Mode
