Formatting a PivotTable

[Chrisch]

Hello,
I have several pivot tables that I really want to keep on the same page. These tables are formatted (centered characters, conditional formatting on some labels, bold, column width).

However, in each update of the spreadsheet, the formatting is lost, so that the tables become too large and that the tab becomes too complicated to read. I am looking for a way to fix the formatting of these tables, so that during an update, the values are updated and not the formatting.

Thank you for your help!

[Macarenas]

try to use grey Field button inyour pivot table at the top of the first column and also use the black down arrow to highlight columns and rows.if you click on gray field button the black down arrow will appear.after left click it shows column for editing.down arrow over grey field buttons shows column headings.

[ThoMas321]

I think it was the width of column that you lose. The rest should be ok.
One possibility without using vba:
- Add a worksheet free
- To form the TCD
- Select all the TCD and copy / Paste Special 'column width' in the free sheet to save.

After an upgrade you do the opposite.

[Glenny]

hi,
you will lose the formating for the time if you change the data on one of the column and it is only possible if your tables are one below the other.