Hello everyone!

I have just come across a rather strange problem!

Ive got some pivot tables in my workbook - Ive noticed that whenever I select limited data in the pivot table, the rest of the cells become blank (and white!)

The original:

\1

And after a selection:

\1

Notice those blank cells? Is there anyway of keeping them yellow like the rest of my page? I tried colouring them in..then tried doing a selection from the pivot table and they became blank again