https://communities.sas.com/t5/SAS-Programming/Allow-pivot-filters-to-be-changed-but-have-table-layout/m-p/649050#M194535 <P>This looks like an Excel question. Have you tried Excel forums?</P> Tue, 19 May 2020 23:30:20 GMT ChrisNZ 2020-05-19T23:30:20Z https://communities.sas.com/t5/SAS-Programming/Allow-pivot-filters-to-be-changed-but-have-table-layout/m-p/648796#M194426 <P class="_1qeIAgB0cPwnLhDF9XSiJM">I have a dashboard which I send out to regional stakeholders that shows specific activity on a selected date. The backing data to this has to be hidden due to control of the message and other data protection issues.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">One regional colleague wants access to some of the backing which could easily/safely be shown in a pivot. The issue is if I protect the worksheet I either have no ability to update the date filter or they can access data points they shouldn't have.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Is there anyway to have the pivot protected but allow only the filter to be adjusted</P> Tue, 19 May 2020 10:49:01 GMT https://communities.sas.com/t5/SAS-Programming/Allow-pivot-filters-to-be-changed-but-have-table-layout/m-p/648796#M194426 MaverickThomas 2020-05-19T10:49:01Z https://communities.sas.com/t5/SAS-Programming/Allow-pivot-filters-to-be-changed-but-have-table-layout/m-p/649050#M194535 <P>This looks like an Excel question. Have you tried Excel forums?</P> Tue, 19 May 2020 23:30:20 GMT https://communities.sas.com/t5/SAS-Programming/Allow-pivot-filters-to-be-changed-but-have-table-layout/m-p/649050#M194535 ChrisNZ 2020-05-19T23:30:20Z