Prevent Pivot table changing background of cells

[asdasdasdadw]

Hi,

Is there a way to stop a pivot table changing the cell background colour? Currently when the table refreshes and is a different size the cells that it no longer covers revert to blank?

And is there a way to filter a pivot table to a specific time? e.g. between 15:34 and 15:38?

Thanks!

[Xx7]

1) I believe you can only change the background color after the pivot table is in place

2) Go to date filters, between, then set the range. See attached.

[asdasdasdadw]

1) I believe you can only change the background color after the pivot table is in place

2) Go to date filters, between, then set the range. See attached.

That filter worked great thanks!

[cyliyu]

sorry to dig out this thread again.
I tried but still cannot prevent the background colour changes each time I refresh the pivot table.
Could someone guide me, please?
The book1.xlsx is a good example, but I can't figure out how it was done.

[protonLeah]

cyliyu,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.