U User Mar 25, 2009 #1 is there any option which helps the format of the pivot table report not to change whenever we refresh or add the data fields
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 Mar 25, 2009 #2 right click on the table Pivot table options 1. don't change the column sizes 2. retain styles (or something like that)
right click on the table Pivot table options 1. don't change the column sizes 2. retain styles (or something like that)
U User Mar 25, 2009 #3 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
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 Mar 25, 2009 #4 Hi Under Table Options you need to Uncheck Autoformat Table, and Check Preserve Formatting
