limited changes in pivot
Hi!!
I have a Pivot table for a P&L report, with differents filters, one of them, must be "locked", and the others must be enables to use. Also I need to lock the file for changes, but with the possibility to use the filters..
Maybe someone have an idea?
Thank you!!
Hi, you can apply a (permanent) filter and then hide the filter area. After this, you can set slicers for additional filtering.
Cheers
Erwin
I started learning VBA because I was lazy...
Still developing.... being more lazy...
Hi!
Is there any way that users could not see the the pivot table fields where you choose the fields for the table ,when they click on the table?
Thnxs
I am not sure what exactly you want, could you give us an example? a worbook with desired result?
Cheers
Erwin
Hi!!
Thank you for your help!!!
I will try again.
Look at the picture I attached.
My question is if there is any way to lock the zone that I remark, so the user will be disable to open and chose field.
Thanks again!
You can for example hide this complete section:
and than add slicers for the items that you want to show.
Please Login or Register to view this content.
Cheers
Erwin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks