close

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.

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 quot;Aquot; and the quot;1quot; and then click on quot;Toolsquot; and click quot;Track
Changesquot; and then click quot;Highlight Changesquot;? I hope that's helpful and good
luck!

quot;DTTODGGquot; wrote:

gt; Hello-
gt;
gt; When you refresh a pivot table, is there any way to highlight or indicate
gt; which values were updated?
gt;
gt; Also, if you format a pivot table, is there anyway to keep the format after
gt; the update? Or do you need to make another sheet with links to the pivot
gt; table?
gt;
gt; Thanks again.

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()