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: [email protected] To: [email protected] CC: [email protected] 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 [email protected] [email protected] New Delhi - 62, India On Tue, Apr 13, 2010 at 6:30 PM, Cecilia Chiderski <[email protected]> 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> 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
