Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Automatically update Pivot Tables
Skip, Thanks for that suggestion, it switched my brain on and started me thinking. I had it in a module but moved it to the workbook object and it worked fine. Thanks for the help. Cheers Kym- KymC
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Automatically update Pivot Tables
I have tried to use the code below to update a number of Pivot tables in a workbook. However I get the error message "Reference is not valid" when the macro gets to the code "pt.refreshTable". I have tried different statements but still not able to get past this error - any...- KymC
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
