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;
- Sep 10 Mon 2007 20:39
Help on Pivot Table Format
close
全站熱搜
留言列表
發表留言