Automatically update Pivot table source range?

[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

 

[Debra Dalgleish]

You can use a dynamic range as the source. There are instructions here:

http://www.contextures.com/xlPivot01.html#Dynamic

 

[Ken Wright]

Take a look here. Just in case you asked that question, Debra said she was
goiung to put this out there ready for you

http://www.contextures.com/xlPivot01.html#Dynamic