| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Added new columns - Pivot Table not refreshing - why?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Added new columns - Pivot Table not refreshing - why?
Did you change the source data range to include the new columns?
If not, try the following: Right-click a cell in the pivot table Choose PivotTable Wizard Click the Back button In Step 2, include all the cells in the source table Click Finish. To make the source range expand automatically, you can use a dynamic range, as described he http://www.contextures.com/xlPivot01.html Joan Sims wrote: -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
| how to delete/clean out the row list in pivot table | Excel Worksheet Functions | |||
| Rearrange data columns in Pivot Table | Excel Discussion (Misc queries) | |||
| add a column to a pivot table that would show the difference between 2 other Columns | Excel Worksheet Functions | |||
Linear Mode
