Greetings. I have created a PivotTable using VBA and connecting to a
SQL database. The Pivot is created fine, but I cannot refresh the
PivotTable. I cannot simply delete the Pivot or the sheet each time I
need to update the data either, but I cannot figure out what code to
write to KEEP the option to Refresh the data. Basically all I have is
a PivotTable with a snapshot in time of the data and it doesn't help
me because I need to refresh the data often.

Does anyone have any thoughts?

I've been struggling on this one for a while and I'm getting close to
deadlines on some items.

Thanks in advance for any help

Paul