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.