• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Formatting

aparvez007

Member
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
 
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.
 
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.
 
Would you mind uploading a sample file?
I really don't get the issue. I hope the video gif works.
 

Attachments

  • cJsrc6T2Rt.gif
    cJsrc6T2Rt.gif
    873.5 KB · Views: 6
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.
 
Back
Top