AboutScottgem 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.
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.
