Recent content by NOT_PROVIDED_354

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...