I don't even know if this will help and I have no idea about Your second
question, but have You tried clicking the upper left hand square that
connects the "A" and the "1" and then click on "Tools" and click "Track
Changes" and then click "Highlight Changes"? I hope that's helpful and good
luck!

"DTTODGG" wrote:

Hello-

When you refresh a pivot table, is there any way to highlight or indicate
which values were updated?

Also, if you format a pivot table, is there anyway to keep the format after
the update? Or do you need to make another sheet with links to the pivot
table?

Thanks again.