Description:
Refreshing a pivot table causes all cells in the table to become protected, and if in a protected sheet the table becomes inoperable. A protected sheet containing an unprotected pivot table automatically activates cell protection in every cell in the table as soon as the table is refreshed.

Steps to Reproduce:
1.open the attached sheet
2.Sheet2 contains a pivot table referencing the data on Sheet1. Note that Sheet2 contains no protected cells except one: A1
3.Refresh the pivot table.



Actual Results:
All the pivot table cells are now protected.
If Sheet2 is then protected, the pivot table becomes inoperable whether or not the "Use pivot table and pivot chart" option is selected. 

Expected Results:
(1) The pivot table cells should retain the cell protection status they are given until they are explicitly changed. 
(2) If the "Use pivot table and pivot chart" option is selected when protecting the sheet, the table should continue to function normally while the other cells of the sheet are protected, regardless of the status of the pivot table cells.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
A User may wish to protect *part* of a sheet with protected cells, while retaining a functional pivot table. In the example of the uploaded file, only the Title in cell A1 should be protected when Sheet2 is protected. 
Or a User may wish to prevent changes to the structure of the pivot table while still allowing the data to be refreshed, and columns or rows to be expanded and collapsed. Currently this is impossible while the sheet is protected. This is unworkable if the workbook is shared with others where sheet protection is needed to prevent unauthorized changes by other users.