PIVOT update of all PIVOTS in all Worksheets

[eramsva]

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

[JosephP]

if you mean refresh them then

Please Login or Register  to view this content.

or you can just use

Please Login or Register  to view this content.

;-)

[eramsva]

IŽll try that. txs