Hi,

My workbook has gotten huge, because it has about 120 pivot tables in it. I'd like to be able to copy and paste values on many of them, but still be able to keep the pivot table formatting. I did find this post about how to do that manually:

http://www.excelforum.com/excel-gene...ormatting.html

I've done this while recording a macro, but it doesn't add any code about going to the clipboard and pasting it from there (which is what allows it to retain the pivot table formatting).

Anyone know the code to do this in a macro?

Thanks!

Don