After doing some testing, the code works if i dont use OLAP, however, with
the number of records being polled from the database, the pivot will error,
but using the cube the code gives the 1004 error.... Strange.

"Eison" wrote:

I'm running multiple pivottable pulling information from a repair database
for a report. One for eachshift. I have the date in the page section and use
it to pul the days transactions. Is there a way to globally change one cell
that changes all pivottables "date" to the date entered into the cell. There
by avoiding the need to manuall change each table, saving myself a few steps.