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 "Table Options..."
Uncheck "Autoformat table"

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Alan Tang" wrote:

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!