Thread: pivotal table problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
  
Posts: 2,979
Default pivotal table problem
Right-click on a cell in the pivot table
Choose Table Options
Remove the check mark from AutoFormat table
Click OK

Vijay Kotian wrote:
In pivot table in Row column one of the field has more than 16 digits and any
changes in the page (in pivot) changes row with less than 16 character. In
short, I need to change column with format cell. Can I keep the format of
cell permanent with some command ? It should not change even with change in
page filter.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply With QuoteReply With Quote