Forum Discussion
EXCEL PIVOT TABLES
I often take a Pivot Table and send it out to individuals as a report. I like to send only values in my report so I often copy the P.T. and Paste Value the results. This action means that the forma...
Right click in your pivot table & click Options. On the Data tab, uncheck 'save source data with file'. You can now copy the PT worksheet to a new workbook & maintain the formatting.