Adding to Pivot Table data range
I'm not sure if I'm missing something really basic.
The data range for my original pivot table has increased by 30+ rows. How do I update the pivot table to include those rows without starting a new pivot table?
eg Original pivot drew from A7:AE490, now it needs to draw from A7:AE575
depending on what version you're using, the steps may be different.
In Excel 2000
click within the Pivot Table
Rt click and select Wizard
you should be on Step 3
click BACK to get to Step 2 where you can change the Range
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1