Any way to perserve Pivot Table formatting

  • Thread starter Thread starter NormanHeyen
  • Start date Start date
N

NormanHeyen

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table formatting 2
Pivot table report invalid 0
Export Pivot table 1
Pivot Table Help! 1
Pivot Table - click through extract data formatting issue 1
pivot table loosing decimals (vba) 1
How to keep the cell borders of the pivot table? 4
How to base a pivot table on another pivot table? 3

Back
Top