ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Identify Updated Results (https://www.excelbanter.com/excel-discussion-misc-queries/72056-identify-updated-results.html)

DTTODGG

Identify Updated Results
 
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.

Narianna

Identify Updated Results
 
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.



All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com