Increasing the Source Data range for an existing Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Folks,
I had already created a pivot table with a set number of rows. However, I
have added extra rows to the original data.

I know that if I had created a dynamic range then the pivot table would be
able to automatically refresh the data range. However, is there another way
of getting around this issue. Can I just go to Pivot table wizard and select
the new range (this might ask me to recreate the Pivot table).

What else can I do to increase my data range while keeping the same Pivot
worksheet? Thanks for your help.

Shams.
 
Shams,

If you're using Excel 2003, you can define a list (Data|List|Create
List...), this will allow entries to go at the bottom of the list and you
will be able to refresh the pivot table to include the new data.
 
Yes, you can update the source data.

1. Right-click inside the pivot table; select PivotTable Wizard
2. Click the Back button
3. Update the range as needed
4. Click the Finish button
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to a 2007 pivot table 2
Pivot table data source 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pre-configuring Pivot table "views" 4
Pivot Table with source spread across multiple worksheets 1
Pivot Table Wizard causes crash 1
Edit the range of a pivot table 4
Pivot Table data source 4

Back
Top