Posted by jeff on January 26, 2002 1:50 PM
I have a worksheet that has multiple pivot tables. All of which are driven by day of the month. They all come from the same data table but each pivot table represents a different reporting item.
Therefore when the data table gets updated and I change the page header for the day of the month (say the 5th), how can I get all of the page headers for all of the pivot tables to refresh their data and change their page header to match the "lead" pivot table? Any ideas would be appreciated.