Lost Pivot table formatting after Paste value of a excel sheet

[sunderlalrwr]

hi.. I have to update data of 10~12 sheets in pivot table and share same to customer.

I copy pivot data sheets in new file & paste value. After paste value pivot table lost formatting i.e header colour, columns fill colour, columns width, number type etc.

I'm facing this issue in office 2019 but in office 2013 there was no such issue of lost formatting.

I need same table as 1st, in place of 2nd table

[#2]

@sunderlalrwr 

If you not paste values but simply paste ?

[#3]

@Sergei BaklanDear, simple paste is not working on pivot table....