Q. I want to use Pivot Tables in my Excel dashboard, but I don’t want the viewer to easily change anything except the Report Filter selection. How do I do that?
A. You’ll see three buttons, which are probably active (orange), on the top right of the Pivot Table Tools Options contextual tab: Field List, +/- Buttons and Field Headers. Toggle these off by clicking each one.
The only functionality left will be the Report Filter. There aren’t any good ways to totally lock this down inside Excel. An astute user can figure out how to activate those options again.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/37103/control-user-access-to-your-pivot-tables "