pivotal table problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Right-click on a cell in the pivot table
Choose Table Options
Remove the check mark from AutoFormat table
Click OK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA For excel 0
date filter in a pivot table 1
Adding to an existing Pivot Table 7
Pivot Table won't Get 'r done 1
Pivot Table Page Break Refresh Problem 0
Pivot Table - Changes 5
XL2007 - Pivot Table Limitations 2
One pivot table cannot overlap another pivot issue. 1

Back
Top