Automatically update Pivot table source range?

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Hi.

When using a Pivot table, I'd like the range it uses to automatically
expand when I add a row to the source table. As it stands now, when I
add a new row, I need to go back to the Pivot wizard and update the
range manually.

Is there a way to automate this?

Thanks!

Ken
 
You must log in or register to reply here.

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

Pivot tables - memory issues - please help 2
pivot table source data expand to new entries when refresh? 4
Adding to an existing Pivot Table 7
How can I change the source data reference to another pivot table? 2
Dynamic data ranges in pivot tables 3
Excel 2007 pivot table source table 1
Pivot tables - Editing the data source shared by multiple pivot ta 1
Question on the occupied field of the pivot table in excel spreadsheet 0

Back
Top