Creating a Dinamic Pivot table

[Droriley]

I have table from which I've done pivot table in different sheet. I am updating this table from time to time, and want it to imply the pivot table. Is that possible?
So far it seems that once I've done pivot - for every little change i the original table I should start all over.

[Bernie Deitrick]

Define your data source as entire columns, or transform the source table into an Excel table object, by selecting the entire table and using Insert / Table

Then just use Data / Refresh all, and any new data will be used in the pivot table.

[Droriley]

Define your data source as entire columns, or transform the source table into an Excel table object, by selecting the entire table and using Insert / Table

Then just use Data / Refresh all, and any new data will be used in the pivot table.

Thanks Bernie. Good to know - I didn't know this "Refresh Data" Stuff.
On similar topic, if you don't mind:
I added chart based on this pivot. Any way that this chart (or any other) would get updated? Should be sensitive both to changing and added values.
Cheers,
Droriley

[Bernie Deitrick]

Use a pivot chart! Acts the same as a pivot table, with regards to new and changed values, also updated using Refresh All. There are fewer options regarding chart types, but that is a worthwhile trade-off for data integrity.

[Droriley]

Use a pivot chart! Acts the same as a pivot table, with regards to new and changed values, also updated using Refresh All. There are fewer options regarding chart types, but that is a worthwhile trade-off for data integrity.

You're right! Awesome. Chart is just fine.