VBA for refreshing pivot tables after changes

[beckyinDC]

my spreadsheet will have 2-4 pivottables with 2-3 pivotcaches.

the data sources will be very manageable- a few columns on a separate spreadsheet for each cache.

updates will occur via pull of data frm other sources via VBA or direct user edits. new rows may be dded. After some update has occurred, I want to have VBA trigger the update to the displayed pivottables when user clicks button.

I had coded 1 pivottable and cache combo where I just deleted the worksheet where the pivottable existed and recreated it when I wanted to refresh. That worked- but it seems like it might be overkill?

no additional columns would have been added, but rows might be added.

if I updated the sourcedata value of the pivotcache, would I need to do anything to the related pivottables to have the changes reflected there?

 

[beckyinDC]

I forgot to explain somthing...

the data source (for the pivottable I have worked out in code) is established by SQL against an external source. Since that data could be updated, added to, or deleted from...I wanted to just delete and recreate that data. Seemed simplest.

so that was why I was originally going with a delete and recreate approach to the pivot table itself.