Hi Dilip! Thanks for your suggestion, but it is not working as expected... If I protect in that way, then the user can not drill into the details anymore. I want the user to drill, to change page fields, but prevent to add/remove fields in the columns/rows....
Date: Thu, 15 Apr 2010 16:45:03 +0530 Subject: Re: $$Excel-Macros$$ Pivot Table - Prevent to add/remove fields except page field From: dilipan...@gmail.com To: excel-macros@googlegroups.com CC: cecic...@hotmail.com Hi Cecilia, Try the solution attached with this email. You need to apply the protection to the spreadsheet and just need to check the checkboxes as shown in the solution. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Apr 13, 2010 at 6:30 PM, Cecilia Chiderski <cecic...@hotmail.com> wrote: Hi, I have a sheet with three Pivot Tables. I want to allow the user to select any value on the Page fields, but I don't want the user to: - Add more page fields - Remove the existing page fields - Add/remove any other field in the Pivot Is there any way to prevent the user to do it?? Thanks, Cecilia " ¿Sabes cómo tener tus amigos de Facebook en Messenger?" Entra aquí -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _________________________________________________________________ Recibe un SMS de tu Hotmail vayas donde vayas. ¡Date de alta! http://home.mobile.live.com/MobileAttach.mvc/?mkt=es-es -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
