Hi, I want to enable/allow refreshing OLAP pivot tables in protected sheets:
I have done privot reports and converted them to formulas with the "OLAP Tools" option, keeping the Report Filter to change the date.
I want to protect(hide) the "CUBEVALUE" formulas, allowing the users to change the date in the Report Filter.
Any advice on how to do it?
Currently i am protecting my worksheets as follow:
![]()
Please Login or Register to view this content.
Bookmarks