![]() |
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. |
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