pivot table

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
 
G

Guest

right click on the table
Pivot table options
1. don't change the column sizes
2. retain styles (or something like that)
 
U

User

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
 
R

Roger Govier

Hi

Under Table Options you need to
Uncheck Autoformat Table, and
Check Preserve Formatting
 

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

Refresh order when refreshing all in a workbook 1
Issue with pivot table 1
Pivot tables - Editing the data source shared by multiple pivot ta 1
Pivot Table - Changes 5
how do i elmininate old data from Report filter on pivot table? 1
Pivot table 1
Adding to an existing Pivot Table 7
How do I save Pivot Table Data 4

Top