Hi! I created a pivot table that accesses data from a table. the problem is, it does not automatically refreshes everytime I updated the data and open the pivot table. Would it be possible to auto-refresh the pivot table? Thanks!!!
I have a form that deletes a re-populates a table depending on a paramater. That table is the one being used by the pivot table. The pivot table would then be opened in excel but it always shows the previously ran report, it does not refresh according to the new set of data on the table.. would it be possible to refresh the excel pivot table everytime I open it from the form?
Take a look at the RefreshTable method of the PivotTable object.
You can try something like this in the Open event procedure of your workbook:
For Each pvtTable In Worksheets("Sheet1").PivotTables()
pvtTable.RefreshTable
Next
Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.