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 here:
http://www.contextures.com/xlPivot01.html
Joan Sims wrote:
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks