This seems like a basic question but I can't figure it out.
I create a pivot table and filter it to show only the sales data for 1 customer. I want to copy this to another file so I can send the pivot table to the customer, but I do not want the pivot table to be able to refresh or view the original data.
I have tried highlighting the pivot table and pasting as values however, I lose all the formatting of the pivot table which I want to keep.
In the pivot table options - data tab I have deselected the "Save source data with file" and "enable show details". This works until the user selects refresh on the pivot table and then all the data becomes viewable.
Any suggestions would be greatly accepted.
Jason
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
VIP
Trusted Members
June 25, 2016
Thanks for the tips. Unfortunately I could not make them work. I have attched a sample workbook that I used to test the different methods with the results on different tabs. I am using excel 2010. One other option is to copy the pivot table and paste it as a picture. The obvious downside is that the person receiving the file can only view the table and not perform any other calculations.
Thanks again for the help.
VIP
Trusted Members
June 25, 2016
1 Guest(s)