Refresh Pivot Tables from Access

[LonnieJohnson]

What is the syntax to refresh an excel pivot table from an Access moduel?

Thanks.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[SkipVought]

Lonnie,

I would NOT do the refresh from Access.

I would set the RefreshOnFileOpen property of the PivotCache in Excel.

ActiveWorkbook.PivotCaches(1).RefreshOnFileOpen = True

Then, whenever the workbook is opened, the PivotTable will update.

If the workbook will be open while Access is updating the table then set the RefreshPeriod property for the pivotcache to an appropriate interval.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com