AllExperts > Business Software 
Search      
Business Software
Volunteer
Answers to thousands of questions
 Home · More Business Software Questions · Answer Library  · Encyclopedia ·
More Business Software Answers
Question Library

Ask a question about Business Software
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Scottgem
Expertise
I can answer some questions on a wide variety of business applications, including MS Office, Lotus Smartsuite, Visio, Notes and many others.

Experience
I have over 16 years of experience as an IT professional, supporting a wide variety of business applications.

 
   

You are here:  Experts > Computing/Technology > Business Software > Business Software > Can the fields in Pivot table be locked -- Ms Access

Business Software - Can the fields in Pivot table be locked -- Ms Access


Expert: Scottgem - 3/30/2009

Question
I want to create a Pivot table where users can filter records from the drop down but I don not want them to be able to move fields from Row area to Column area or Filter area and vice versa.

Answer
You can have them apply criteria to a query that will be used as the source of the Pivot. then generate the pivot so the user doesn't see the steps taken.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

Thanks for providing that link. I was close, I was trying to see if the AllowEdits property would restrict it but that didn't work in my test. I really don't use pivot tables much (probably should use them more). So I haven't dealt with this before.

And kudos to you for finding it on your own. Too many of the people that ask questions, refuse to try and find even the simplest answers.

Scott<>

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.