View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M. Wirtzfeld M. Wirtzfeld is offline
external usenet poster
 
Posts: 1
Default Prevent Pivot Table Resizing

Hello,

A quick question regarding pivot tables.

Is it possible to prevent Excel from resizing column widths when a field
button is used to alter data selection? Locking cells and protecting the
worksheet will not work; the field buttons can not be used when the
worksheet is protected.

Any advice or suggestion would be greatly appreciated.


Kind Regards,

Michael.



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----