In Excel 2007 when you copy paste sheets as values it will not paste the pivot table formats. Which is really annoying.
I'm trying to create a macro to export (copy and paste certain sheets as values) to a new workbook.
I can get it working (though the code looks convoluted and messy) without pivot table formats but it wont bring those across...
This is where i'm at.
Any help condensing my code and/or regarding the pivot table issue would be appreciated.
Ideally i'd like to be able to copy paste the sheets across without having to select them like i do.
Thanks in advance
Mike
Bookmarks