Thread
:
PLEASE HELP** Pivot table auto updating
View Single Post
#
2
Posted to microsoft.public.excel.programming
Roelof van Wyk
external usenet poster
Posts: 5
PLEASE HELP** Pivot table auto updating
You need this line in your macro.
ActiveSheet.PivotTables("PivotTable1").PivotCache. Refresh
You can record it by clicking on the Pivot tabel and refresh ! it.
Reply With Quote
Roelof van Wyk
View Public Profile
Find all posts by Roelof van Wyk