Svilen;

You can update any pivot table upon opening by setting that feature in the
pivottable options dialog box.

--
Regards;
Mark Rosenkrantz
--
Spreadsheet Solutions
Uithoorn
Netherlands
--
E:
W: www.spreadsheetsolutions.nl
--

"Svilen Pachedzhiev" wrote in message
...
Hi,
I have several sheets with data and one sheete with several pivot tables
for
this data.
The common thing between them is the date field they always shuld be
updated
for the same date. I put the date in the PAGE field of pivot table wizard.
So is it posible to update all my PTs to the same date with a macro?

Thanks,

Svilen