I have created a Pivot table to summarize the data entered by my team members on a different sheet.
I want to give only view or print access to the Pivot table sheet for my team. If I protect the sheet with a password, an error message is getting displayed that the Pivot tables on protected sheet cannot be refreshed. Kindly advise how I can I overcome this issue.
Thanks a lot for your kind advise.