When a pivot table is updated and the number of rows/columns is reduced (the table is contracted), how can I keep the formatting of the previously occupied cells the same as the pivot table background color. Now when the table is contracted the empty cells are blank.
i.e. When the table contracts, I want the cells that used to have data in them to be filled with a certain color.
i.e. When the table contracts, I want the cells that used to have data in them to be filled with a certain color.