Pivot Formatting

[aparvez007]

Hi,

Please help
I am using Excel 2019 and using AutoFormat for Pivot table when i am converting pivot using paste special Value pivot is loosing its formatting.

Thanks,
Parvez

 

[GraH - Guido]

Hi Parvez,
That's exactly the point, no, of paste value? Perhaps try paste special twice:

1. values
2. formats

 

[aparvez007]

Hi Parvez,
That's exactly the point, no, of paste value? Perhaps try paste special twice:

1. values
2. formats

Thanks for your reply

If I am making pivot to value it's loosing it's format how can I again paste format when there is no formatting left.

 

[GraH - Guido]

Your original copy does contain the format, right?
So you do paste special, first select values. The copy remains available on the clipboard. Then redo paste special formats.
Or even vice versa.

 

[aparvez007]

Your original copy does contain the format, right?
So you do paste special, first select values. The copy remains available on the clipboard. Then redo paste special formats.
Or even vice versa.

Yes original copy have format but after copy paste special value pivot lose the format and paste special format is not working.

 

[GraH - Guido]

Would you mind uploading a sample file?
I really don't get the issue. I hope the video gif works.

 

[aparvez007]

Would you mind uploading a sample file?
I really don't get the issue. I hope the video gif works.

Thanks for your effort sir
I am copy paste on same pivot that's why it's not working.
In earlier version pivot not loosing Auto formatting when I am copy paste value.