View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Svilen Svilen is offline
external usenet poster
 
Posts: 1
Default Update multiple pivot tables

So, nobody knows anything to help?!? ....

It should be just 2 lines of code....

On Jul 7, 3:27*pm, "Svilen Pachedzhiev"
wrote:
Hi,
I have several sheets with data and one sheete with severalpivottables for
this data.
The common thing between them is thedatefield they always shuld be updated
for the samedate. I put thedatein the PAGE field ofpivottable wizard.
So is it posible toupdateall my PTs to the samedatewith a macro?

Thanks,

Svilen