Hi all,
Is there a way to, with a VBA macro, update all PIVOTs in several worksheets without refering to the specific PIVOTS. In other words, if I add a PIVOT table in some of the sheets i should not have to update my macro.
BR,
Martin
Hi all,
Is there a way to, with a VBA macro, update all PIVOTs in several worksheets without refering to the specific PIVOTS. In other words, if I add a PIVOT table in some of the sheets i should not have to update my macro.
BR,
Martin
if you mean refresh them then
or you can just useSub Refresh_pivots() Dim PC As Excel.PivotCache For Each PC In ActiveWorkbook.PivotCaches PC.Refresh Next PC End Sub
;-)activeworkbook.refreshall
Josie
if at first you don't succeed try doing it the way your wife told you to
IŽll try that. txs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks