close

Hello:

Is it possible to make the pivot table format not change? It was because
I have change some of the color on Cell but it will change the format
when I refresh the data.

Thanks!

Right-click on the pivot table to pull up the menu.
Select quot;Table Options...quot;
Uncheck quot;Autoformat tablequot;

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.quot;Alan Tangquot; wrote:

gt; Hello:
gt;
gt; Is it possible to make the pivot table format not change? It was because
gt; I have change some of the color on Cell but it will change the format
gt; when I refresh the data.
gt;
gt; Thanks!
gt;

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

    software

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