Set Pivot Table source as ADO Recordset

[bconner]

I have an existing Excel 2007 Pivot table named Pivot1. I would like to change the pivot source to an ADO recordset and refresh. Below is the code I have so far.

Please Login or Register  to view this content.

[rdg515]

I have the exact same issue, bump.

I update my pivot cache with an ado recordset but then the refresh option becomes disabled so a user cannot manually update the pivot table.