Refresh a PivotTable using VBA (SQL generated Pivot)
 

Pete, when the PivotTable is created there is no option to Refresh it
when I right click on it. The items you suggested make sense, but they
don't work the way this is set up. I was curious if I have to have this
re-connect first to get the data and then refresh the Pivot with the new
data. I guess for now I'm still stuck on this one.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!