You cannot create or make changes to PivotTable reports in a shared workbook. If you copy a report and paste it in a shared ...

You cannot create or make changes to PivotTable reports in a shared workbook. If you copy a report and paste it in a shared workbook, only the cell contents are pasted.To make a copy that you can edit and rearrange, in the same instance of Excel, paste the report into a workbook that is not shared.