pivot table

  • Thread starter Thread starter User
  • Start date Start date
U

User

is there any option which helps the format of the pivot table report not to
change whenever we refresh or add the data fields
 
right click on the table
Pivot table options
1. don't change the column sizes
2. retain styles (or something like that)
 
Thank you for quick response but sorry to say that it doesn't work in pivot
table options "preserve cell formatting on update" and autofit colum widths
 
Hi

Under Table Options you need to
Uncheck Autoformat Table, and
Check Preserve Formatting
 
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

Pivot ungrouping on refresh? 3
Refresh order when refreshing all in a workbook 1
Pivot Table - Changes 5
Excel VBA For excel 0
How do I save Pivot Table Data 4
Pivot tables - Editing the data source shared by multiple pivot ta 1
Issue with pivot table 1
Pivot Table - NUMBER FORMAT option does not appear in field settin 3

Back
Top