Forum Discussion
Itchn2go
Nov 14, 2020Copper Contributor
remove access to Power Pivot
I have a report and I don't want people to be able to open the data tables in the Power Pivot -> Manage. I would still like to let people drill down into the data. I know if I password protect th...
Itchn2go
Nov 15, 2020Copper Contributor
Thanks for the response. No, i need to protect the data in a shared Pivot Table Report
I need to disable the Power PIvot Manage function - shown in the attachment while still letting people drill down into the filter data. all slicers and sheet protections are in place. If I protect the structure of the workbook I accomplish the goal. BUT I also cannot drill down which is what i want.
Ability to drill down but lock out the ability to manage the power pivot data.
NikolinoDE
Nov 15, 2020Platinum Contributor
Maybe this information will help you
Unshare a data cache between PivotTable reports
https://support.microsoft.com/en-us/office/unshare-a-data-cache-between-pivottable-reports-87188806-0c24-4d17-b2f7-9e3a4a05542b?ui=en-us&rs=en-us&ad=us
About the shared workbook feature
https://support.microsoft.com/en-us/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534?ui=en-us&rs=en-us&ad=us
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Unshare a data cache between PivotTable reports
https://support.microsoft.com/en-us/office/unshare-a-data-cache-between-pivottable-reports-87188806-0c24-4d17-b2f7-9e3a4a05542b?ui=en-us&rs=en-us&ad=us
About the shared workbook feature
https://support.microsoft.com/en-us/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534?ui=en-us&rs=en-us&ad=us
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)