Hi everyone,

I've got a (probably small) problem with pivot tables.
So I've got a pivot table which I can filter through slicers. That means, the amount of used rows in the pivot table changes.

I'm doing this as a part of a dashboard. To make it look prettier the whole worksheet is painted in a dark grey and the grid is invisible.

My unfiltered pivot table has got 10 used rows. When I filter it, it might only have 3 used rows.
But now the other 7 rows are set back to the standard excel format (white, with visible grid).

So the refreshing of the pivot table changes the format of the worksheet "underneath".
Is there any way to prevent this from happening?

Thank you!