At least the borders? We have a pivot table that has many columns of
data (18 months) and it is very useful to have an underline or row
shading to help follow across this large table.

We can set the borders and it works OK, but as soon as the data is
updated, the format is removed. Even as simple as selecting one of the
categories from the drop down clears the formatting. This doesn't seem
right.

What are we doing wrong? Should the formatting be set immediately
after creating the table? Or is there some trick to this?

Tried to pick a report style, but picking one seemed change the table
completely. And even that didn't seem to stick. Is there a way to
create a customized version of a style?

If possible, would prefer a non-VBA solution.

Thanks!
Norman

Hi Norman

Go to Table Options in the Pivot Table and uncheck Autoformat, and ensure
the Preserve Formatting is checked.
Does this achieve what you want?

Regards

Roger Govier


NormanHeyen wrote:
> At least the borders? We have a pivot table that has many columns of
> data (18 months) and it is very useful to have an underline or row
> shading to help follow across this large table.
>
> We can set the borders and it works OK, but as soon as the data is
> updated, the format is removed. Even as simple as selecting one of the
> categories from the drop down clears the formatting. This doesn't seem
> right.
>
> What are we doing wrong? Should the formatting be set immediately
> after creating the table? Or is there some trick to this?
>
> Tried to pick a report style, but picking one seemed change the table
> completely. And even that didn't seem to stick. Is there a way to
> create a customized version of a style?
>
> If possible, would prefer a non-VBA solution.
>
> Thanks!
> Norman